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

219 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
elodeas83696(None) 
elodea738671elodea_
elders74817302el_ders
elides74420692elide_s
elopers95112942elopers
elopes85918162elope_s
eluders8409902eluders
eludes75417682elude_s
epodes94315562epode_s
erodes74819882erode_s
lodens74315062_lodens
lodes66436912_lode_s
melodias1148702melodias
abodes94417513abode_s
alders74218423al_ders
alodia71112453alodia_
alodial899953alodial
aloes54933673alo_e_s
alohas9411703alo_has
altheas1038233altheas
aludels835303aludels
anodes74418763anode_s
beloveds14153963beloveds
bladers104214683bladers
blades95221253blade_s
blokes123813883bloke_s
blondes104213163blonde_s
blowers124313593blowers
bodegas1135483_bodegas
bodes84935103_bode_s
boheas114013213_boheas
boreas85421733_boreas
celosias1048903celosias
choreas124414203choreas
clades94920463clade_s
cloacas1136233cloacas
clods85320863clod__s
cloners94514823cloners
clones84526563clone_s
closers94415323closers
closes85425593close_s
closets94611603closets
clovers125114663clovers
cloves114918823clove_s
clowders14357473clowders
clozes174915563cloze_s
codas84724243_cod_as
codecs115112933_codecs
codeias103911223_codeias
codens94821013_codens
coders95426983_coders
codes86247293_code_s
decoders122810413decoders
decodes113914983decode_s
deluders10156433deluders
deludes91810643delude_s
diodes83915783diode_s
eddoes8199143eddoe_s
edemas9310503e__demas
egoless836983egoless
eiders74321363e_iders
elaters74420193elaters
elates65032363elate_s
elder64020023el_de_r
eldest72912683el_dest
eldress835003eldress
elds56324853el_d__s
elevens1066803elevens
elide64922643elide__
elided84814673elide_d
elites66027123elite_s
eloigns8425353eloigns
eloiners8128153eloiners
eloins65419383elo_ins
elope75219343elope__
eloped95914143elope_d
eloper85414153elope_r
elude64517623elude__
eluded84612773elude_d
eluder73712213elude_r
elutes64020313elute_s
elvers93814983el_vers
elves85118743el_ve_s
emodins1039433emodins
emoters94712873emoters
emotes84620283emote_s
emydes1236173emyde_s
encoders1137513encoders
encodes10310643encode_s
endear74110013e_ndear
endears83710053e_ndears
enders74324053e_nders
epode85114093epode__
epopees1137233epopees
eposes84418783epose_s
erode64520993erode__
eroded84313583erode_d
erodent8313823erodent
eroses65327053erose_s
etudes73811603etude_s
eulogias946553eulogias
eupneas935233eupneas
evaders1136933evaders
evades1039023evade_s
evokers14386793evokers
evokes13459683evoke_s
exoderm1754893exoderm
exoderms1864493exoderms
exodos1435943exod_os
exodus1434653exod_us
exogens1536883exogens
exploders1944173exploders
explodes1845803explode_s
exudes143710363exude_s
fleas86423663fl__eas
floes85528143flo_e_s
flooders12257833flooders
floras94715693flo_ras
florets1039853florets
flotas94013003flo_tas
flowers133413173flowers
folders113514393folders
foveas1238623_foveas
geladas936313gelad_as
gelders93812573gel_ders
geodes8412153geode_s
glades84820343glade_s
gledes84915133glede_s
gliders94811843gliders
glides84518863glide_s
globes94314543globe_s
glorias81610323glorias
glossas8438193glossas
glovers114310883glovers
gloves104115183glove_s
glowers113412093glowers
glozes164313353gloze_s
godets8410933_godets
holders113715903holders
ideas65919013__ideas
ladens74516233_ladens
laders74927763_laders
lades65141273_lade_s
leadens83610983leadens
leaders83819603leaders
leas45954183_l__eas
lenders84419643lenders
leones64417723leone_s
leudes75314093leude_s
loaders83413433_loaders
lobes75331003_lobe_s
lode56240113_lode__
loden66621143_lode_n
lodgers95113833_lodgers
lodges86820153_lodges
loess55714703_lo_ess
loges66534203_loge_s
loners64225813_loners
looeys95110123_looeys
loofas9429833_loofas
lopers84424143_lopers
lopes76437343_lope_s
loreal63814313_loreal
lores55045403_lore_s
losels64714583_losels
losers65123583_losers
loses56742013_lose_s
lotas55926303_lo_tas
loudens8368053_loudens
loumas84812333_loumas
lovers94223433_lovers
loves85332013_love_s
lowers94624923_lowers
lowes85732463_lowe_s
loxes125227473_loxe_s
ludes65728853_lude_s
melders103213913mel_ders
melodeon1143443melodeon
melodeons1243353melodeons
melodia1038883melodia_
melodicas1444853melodicas
melodies11310123melodies
models94216353_models
modems114610763_modems
modes85537413_mode_s
molders103315553molders
nodes64633493_node_s
odas57230263__od_as
odea56224573__odea_
odes57243243__ode_s
pelorias10410593pelorias
pelotas9410723pelo_tas
pleas75627033pl__eas
plodders1235523plodders
plods85719293plod__s
plovers123611833plovers
plowers123812243plowers
polders103617373polders
proteas92015123proteas
recodes102918633recode_s
reloaders1036423reloaders
remodels1135663remodels
rodeos75314503_rodeos
rodes614039083_rode_s
sliders83515223sliders
slides73922183slide_s
sloes54728873slo_e_s
slopers94213093slopers
slopes84820453slope_s
slovens10316573slovens
sodas64123543_sod_as
solders83517773solders
spodes94817433spode_s
telomes9310533telome_s
toeas55726423_to_eas
vodkas1443543_vodkas
welders113313413wel_ders
yodels104610073_yodels
zoeas145815613_zo_eas

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.390458182.1
2DLD Change Limit1340272197.11018850.5
3Display Results2192190.0762881.6
 (SQL Overall)1786912197.57623586.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.