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 “ecdyses” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

115 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
ecdyses133341(None) 
ecdysis1343221ecdysis
ecdyson1342212ecdyson
ecdysones1541692ecdysones
ecdysons1442112ecdysons
ectases92911672ectases
ectypes1434802ectypes
accuses114112193accuses
acidoses1136773acidoses
aldoses8311203aldoses
becurses1236723becurses
carses85233653_carses
cases75048383_c_ases
causes88026473_causes
cayuses12188403_cayuses
ceases84427073_ceases
cedes84927333ced__es
censes83721803_censes
cerises94722253cerises
ceruses93716233ceruses
cesses84221363_cesses
chases115128233_chases
choses115825133_choses
chyles144813283_chyles
chymes165912153_chymes
closes85425593_closes
copses104922483_copses
corses84433463_corses
coses76949493_c_oses
crases85532313_crases
crises84529433_crises
cruses88127713_cruses
curses85328273_curses
cusses84522773_cusses
cyeses11510123_cyeses
cymes1210118923_c_ymes
cysts105912773_c_ysts
deceases11410153deceases
doses65938503__doses
dyes85331893__dy_es
dykes135215573__dykes
dynes95917583__dynes
eases56041613e__ases
ecartes94212563ecartes
ecdysial1442633ecdysial
ecdysiast1551803ecdysiast
ecdysone1441813ecdysone
ecesis84611203ec_esis
ecesises1037023ecesises
eches106322163ec__hes
echoes114715523ec_hoes
eclipses1244223eclipses
ecotypes1545053ecotypes
ectasis9249613ectasis
ectype1334283ectype_
eddies83313163e_ddies
eddoes8199143e_ddoes
edges75718743e_d_ges
ediles74016983e_diles
educes94011953e_duces
effuses1335903effuses
egises7312493e_gises
elapses957663elapses
eldress835003eldress
emdashes14224303emdashes
emeses86114963e_meses
emydes1236173e_mydes
encases93116053encases
enchases13310273enchases
encloses10911063encloses
encysts1244313encysts
endashes12217453endashes
endites83717063endites
endives113710693endives
endless839833endless
endorses959973endorses
endues73813903end_ues
endures83314603endures
entases72816273entases
enzymes2164413enzymes
eposes84418783e_poses
erases64425403e_rases
eroses65327063e_roses
erses55826803e__rses
eses45336103e___ses
esses56422973e__sses
ethoses10311763ethoses
ethynes13377573ethynes
euclases1039223euclases
evulses1035043evulses
excesses1736753excesses
excises1638933excises
excuses1638903excuses
exoduses1644803exoduses
exposes1639963exposes
eyases94513683e_yases
eyasses10388023eyasses
eyes75837883e__y_es
eyres84921773e__yres
ictuses938303ictuses
iodises83413633iodises
judases1534443judases
kumyses1633143kumyses
lyses84518253__lyses
necroses10310573necroses
niduses837013niduses
odyles10348563_odyles
pectases122411193pectases
physes14399783_physes
recesses10312323recesses
recluses105111733recluses
recuses94619463rec_uses
redyes104214093redy_es
scouses93313243scouses
sudses74114503sud_ses

Search took 8 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 Filter1786911340270.420425454.8
2DLD Change Limit1340271156.89319443.9
3Display Results1151150.0303833.3
 (SQL Overall)1786911157.34324334.9
 
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.