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

370 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
echoer11401110(None) 
echoed125211151echoed
echoers12459691echoers
echoes114715521echoes
echoey14397851echoey
achier113914262achier
cheer105420382_cheer
choir105313602_choir
choker154314372_choker
choler113717152_choler
chore105126762_chore
cooer74831012_cooer
eche97520282ech_e_
eched116919222ech_ed
eches106322162ech_es
echo96615952echo__
echoic1339042echoic
echos105216462echo_s
ephor10310012epho_r
etcher113912942etch_er
ether84518772eth_er
hoer76533982__hoer
ichor1039482icho_r
lecher113415852lech_er
ocher104516102och_er
shoer84722162_shoer
techier1269242techier
abhor10411063abho_r
ache96829823ach_e_
ached119227833ach_ed
aches106132293ach_es
achoo10315083acho_o
actor71116073acto_r
acuter84412863acuter
aether94213673aeth_er
anchor113911973ancho_r
archer115016243arch_er
ashier94714833ashier
ashler9459973ashler
ashore9414613ashore
beachgoer1742313beachgoer
beachier1538803beachier
beckoner1654963beckoner
beechier1535633beechier
belcher143511493belch_er
bencher144113483bench_er
caber95126833_caber
cager85229223_cager
cahier113615773cahier
caner75334773_caner
canoer85121073canoer
caper94831623_caper
carer74942333_carer
cater74840723_cater
caver105629063_caver
ceder85322243_ceder
ceiler84013963ceiler
censer84516583censer
center84421413center
chafer144714573_chafer
chair105519633_chair
char95132153_ch_ar
chare105231983_chare
charr104821783_charr
chaser114918383_chaser
chawer144314413_chawer
cheder125113493_cheder
cheek145115713_cheek
cheep125416503_cheep
cheero114712933_cheero
cheers114518913_cheers
cheery144913153_cheery
chef125125623_ch_ef
chert105232103_ch_ert
chew126622133_ch_ew
chewer145512623_chewer
chez184519023_ch_ez
chicer134513603_chicer
chider125116053_chider
chief134419483_chief
chiel104918973_chiel
chimer135517203_chimer
chirr105015903_chirr
chock164316613_chock
choicer14197893_choicer
choirs114911883_choirs
choke145118023_choke
choked164914793_choked
chokers164311523_chokers
chokes154917383_chokes
chokey184811713_chokey
chokier1638043_chokier
choky175711223_choky
chola104718033_chola
cholera12409093_cholera
cholers124215203_cholers
cholo105217973_cholo
chomp144815663_chomp
chomper163810073_chomper
chon96627793_cho_n
chook146015043_chook
chooser124412973_chooser
chop116024923_cho_p
chopper163611893_chopper
chops125019873_chops
chord115917263_chord
chorea115216083_chorea
chored125321883_chored
chores114828023_chores
chose105925403_chose
chosen116014133_chosen
choses115825133_choses
chott103923933_chott
chouser125212943_chouser
chow125820993_cho_w
chowder16387813_chowder
chowed154914653_chowed
chows135618203_chows
churr104512853_churr
cider84723313_cider
citer74827333_citer
cloner84418093_cloner
closer84918203_closer
clour76617283_clour
clover114617123_clover
coder86134223_coder
coed77140543_c_oed
coheir1137583_coheir
cohere112716993_cohere
coir66327243_c_oir
comer95832693_comer
cooed84534343_cooed
cooee74531023_cooee
cooers84324563_cooers
cooey105828223_cooey
cooker124722453_cooker
cooler84824713_cooler
cooper104221123_cooper
cooter85128613_cooter
coper95336093_coper
cor59960943_c_o_r
core67263113_c_ore
corer75538873_corer
cover105430773_cover
cower104531773_cower
coyer105222843_coyer
crier74724463_crier
crore74922873_crore
crower114117563_crower
crozer175112843_crozer
cuber95222533_cuber
curer75030753_curer
cuter74728233_cuter
cyber124910383_cyber
cyder114611133_cyder
decayer13339353decayer
decider114213183decider
decker135215993dec_ker
decoder113712293decoder
decor84717573dec_o_r
decoyer13348683decoyer
decreer10269123decreer
decrier102713553decrier
doer57734703__doer
eager65526973e_ager
earner63617223earner
easier64218463easier
easter65027983easter
eater54639843e_ater
echard1249223echard
eching126315563eching
echini114710433echini
echogram1646393echogram
echoing1358613echoing
echoism1447363echoism
echoless1345603echoless
echt95722903ech__t
eclair836813eclair
ecotour944363ecotour
ectoderm1383793ectoderm
ectomere1245753ectomere
eddoes8199143eddoes
edger75215953e_dger
edgier8469733edgier
eelier64216463eelier
eerier64320023eerier
eger55923573e__ger
egger74414413e_gger
eider64624743e_ider
either94517423either
elater64724203elater
elder64020023e_lder
elmier839813elmier
eloper85414153eloper
eluder73712213eluder
elver85216243e_lver
ember95516803e_mber
embower14267403embower
emeer74815363e_meer
emmer94314463e_mmer
emoter85415193emoter
empower14217033empower
enchaser1346693enchaser
encloser10107183encloser
encoder1038633encoder
encore8314773encore
ender64325863e_nder
endower1138483endower
enjoyer1744383enjoyer
enrober9218623enrober
enter54726383e_nter
envier939673envier
ephod1139123epho_d
ephods1238363ephods
ephori1139603ephori
ephors11311403ephors
epimer10109153epimer
eraser64216333eraser
error53712233erro_r
escaper11368843escaper
eschar1136533esch_ar
eschew1436333esch_ew
eschewer1643173eschewer
esker94412983e_sker
ester54727713e_ster
etched123613703etch_ed
etchers123411293etch_ers
etches114217763etch_es
ethers94518413eth_ers
ethos85514193etho_s
ethoses10311763ethoses
ethoxy1933923ethoxy
euchre11137663euchre_
euchred13106163euchred
euchres1288663euchres
evader1036813evader
evener91010623evener
ever77027693e__ver
eviler94811893eviler
evoker13467913evoker
ewer77523983e__wer
excimer1834963excimer
exciter1637753exciter
excuser1635813excuser
exhort16410803exhort
exhorter1845353exhorter
exhumer1943463exhumer
exiler134712183exiler
exposer1637413exposer
eyer76127283e__yer
fetcher153510393fetch_er
fuhrer1235033fuhrer
geckoes14325793geckoes
goer56827103__goer
heckler16278573heckler
hector113312653hecto_r
her66547813__h_er
hoar76729163__hoar
hoe67562723__hoe_
hoed87837983__hoed
hoers85724923__hoers
hoes75755733__hoes
homer105828453__homer
honer85332093__honer
hoper105829143__hoper
hoser811529763__hoser
hour75827313__hour
hover115524133__hover
ichors11310423ichors
icier74313753ic_ier
icker114018443ic_ker
ickier12439923ickier
incher114114033inch_er
itchier12247673itchier
ither84617603ith_er
leacher124014843leach_er
leachier1337253leachier
leched123716003lech_ed
lechers123313963lech_ers
lechery15257643lech_ery
leches115421313lech_es
lechwe1435113lechwe_
lechwes1535063lechwes
lector83514983lecto_r
mahoe10315573mahoe_
mahoes11313103mahoes
meshier123410853meshier
necker124012793nec_ker
nether94014163neth_er
ochers113915303och_ers
ochery14319443och_ery
ochone11311293ochone
ochre103411593ochre_
ochrea11316643ochrea
ochred12328003ochred
ochres113510833ochres
ocker113915753oc_ker
other84219103oth_er
peacher144216073peach_er
peachier1548623peachier
peched144915343pech_ed
pecker144615363pec_ker
peckier153910523peckier
percher143313423perch_er
poechore1547853poechore
reacher123718293reach_er
rechew14310213rech_ew
rechose121312043rechose
rechosen13127033rechosen
reciter94117263reciter
reckoner1446063reckoner
recover124312623recover
rector84019753recto_r
reechier1336673reechier
reechoed1436083reechoed
reechoes1338413reechoes
reshoe92816483reshoe_
reshoed112212153reshoed
reshoes102316033reshoes
reshower14107063reshower
richer114015043rich_er
scaler84321603scaler
scarer84524613scarer
schemer1477963schemer
schlep1347093schlep
schmear1484043schmear
schmeer1475363schmeer
schmoe13328333schmoe_
schmoes14308543schmoes
scholar1236953scholar
school11410723school
schooner1336623schooner
schorl1179813schorl
scooper113812033scooper
scooter93312873scooter
score75526743sc_ore
scorer84818263scorer
scoter83815483scoter
scour75315533sc_our
seceder10329573seceder
sector83415933secto_r
securer958253securer
senhor93010813senho_r
sheer84726893_sheer
shier85428943_shier
shoe75933443_shoe_
shoed95723013_shoed
shoers94518333_shoers
shoes85429663_shoes
shore85432653_shore
shover124515993_shover
shower124315113_shower
shyer114714783_shyer
teacher123714833teach_er
teched124014433tech_ed
techie11511723techie_
techies12513603techies
tetchier1336453tetchier
tether93716103teth_er
tocher114014913toch_er
undoer73113043undoer
usher84517763ush_er
vector113212063vecto_r
vetoer93410063vetoer
welcher15319393welch_er
wencher153811133wench_er
wether123315393weth_er
whore116018043_whore
wooer84316693_wooer
yachter1534913yachter

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127163704.80023482.5
3Display Results3703700.1233008.1
 (SQL Overall)1786913705.29633740.7
 
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.