Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “ellipses” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

62 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
ellipses104434(None) 
eclipses1244221eclipses
ellipse944011ellipse_
ellipsis1043271ellipsis
eclipse1144192eclipse_
eclipsed1343482eclipsed
eclipser1242802eclipser
eclipsers1342642eclipsers
eclipsis1243702eclipsis
elapses957662e_lapses
aliases7914493_aliases
allies63827673alli__es
bellies94023723belli__es
blisses94911513_blisses
calipees1247413calipees
callipees1345303callipees
cellists1038563celli_sts
collapses1344683collapses
collinses1138283collinses
cullises103111313culli_ses
dellies83622213delli__es
eclipsises1452323eclipsises
egises7312493e_gi_ses
elapse857523e_lapse_
elapsed1056113e_lapsed
elegises9128823elegises
elides74420693e_li_des
elites66027123e_li_tes
ellipsoid1252243ellipsoid
ellipsoids1351633ellipsoids
elliptic1254753elliptic
elopes85918163e_lop_es
enlists749393enli_sts
eolipiles1144483eolipiles
exciples1964773exciples
excises1638933exci_ses
fellies104119743felli__es
glimpses1343953glimpses
illites72415013illi_tes
jellies143816533jelli__es
jellifies1946273jellifies
kellies113516853kelli__es
lapises93513463_lapises
lapses85217693__lapses
lewises1039133lewi_ses
lipases9209483__lipases
nellies73418723nelli__es
pelisses1048483pelisses
pellicles1344933pellicles
pelvises1337273pelvi_ses
plisses94411773_plisses
realises82420183reali_ses
relapses1038033relapses
slipes84921413_slip_es
syllepses1442843syllepses
talipes9611603talip_es
tallises82713263talli_ses
tellies73820513telli__es
traipses1036873traipses
trellises947023trelli_ses
valises103516273vali_ses
wellies103719073welli__es

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.403443402.0
2DLD Change Limit146162628.56317069.0
3Display Results62620.0331878.8
 (SQL Overall)178691628.99919856.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.