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 “eclipses” 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.

69 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
eclipses124421(None) 
eclipse1144181eclipse_
eclipsed1343471eclipsed
eclipser1242791eclipser
eclipsers1342641eclipsers
eclipsis1243691eclipsis
ellipses1044341ellipses
eclipsises1452312eclipsises
elapses957662e_lapses
ellipse944012ellipse_
ellipsis1043272ellipsis
aliases7914493_aliases
blisses94911513_blisses
calipees1247413calipees
cerises94722253ceri_ses
classes94717943_classes
clauses93813323_clauses
clepes104214623_clep_es
cliches144213743_cliches
climes104720003_cli_mes
clines84926043_cli_nes
clipped14439833_clipped
clipper133710323_clipper
clippers14368843_clippers
clips96018303_clip__s
cliques18309203_cliques
closes85425593_cl_oses
copses104922473_c_opses
corpses113913803_corpses
cripes105120873_crip_es
crises84529433_cri_ses
cuisses9319883_cuisses
declasses1246443declasses
declines113315803decli_nes
ecdyses1333413ec_dyses
ecesises1037023ecesises
eclipsing1443743eclipsing
ecliptic1455333ecliptic
ecliptics1553653ecliptics
eclogues1144573eclogues
ectases92911673ec_tases
ectypes1434803ectyp_es
egises7312493e_gi_ses
elapse857523e_lapse_
elapsed1056103e_lapsed
elides74420693e_li_des
elites66027123e_li_tes
elopes85918163e_lop_es
encloses10911053encl_oses
enlists749393enli_sts
eolipiles1144483eolipiles
euclases1039223eucl_ases
exciples1964773exciples
excises1638933exci_ses
glimpses1343953_glimpses
lapses85217693__lapses
lipases9209483__lipases
pelisses1048483pelisses
plisses94411773_plisses
realises82420183reali_ses
recipes113314463rec_ip_es
reclines103718543recli_nes
recluses105111733recl_uses
relapses1038033relapses
scolioses1155613scolioses
slipes84921413_slip_es
talipes9611603talip_es
traipses1036873traipses
valises103516263vali_ses

Search took 9 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.313570897.8
2DLD Change Limit146162698.32617554.9
3Display Results69690.0332090.9
 (SQL Overall)178691698.67220605.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.