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

252 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
eschew143633(None) 
eschews1534551eschews
chew126622132__chew
eche97520282e_che_
eched116919222e_ched
eches106322162e_ches
eschar1136522eschar
escheat12410402escheat
eschewal1643132eschewal
eschewed1743442eschewed
eschewer1643172eschewer
escrow1135912escrow
etched123613702etched
etcher113912942etcher
etches114217762etches
rechew14310212rechew
screw109318542_screw
shew108030762_s_hew
ache96829823_ache_
ached119227833_ached
aches106132293_aches
arched125717323arched
archer115016243archer
arches114822043arches
ashed97829773as_hed
ashen87818673as_hen
ashes86230613as_hes
askew12529413as_kew
bached145519893bached
baches135426943baches
beached154516553beached
beaches144120653beaches
beechen14367703beechen
beeches143413883beeches
belched154011843belched
belcher143511493belcher
belches143514343belches
benched154713943benched
bencher144113483bencher
benches143918603benches
beshrew1554393beshrew
bestrew1248003bestrew
boche124216953boche_
boches134618523boches
cache125122483cache_
cached145419203cached
caches137926913caches
cachet134526413cachet
cashew144311453cashew
chaw126224633__chaw
chef125125623__chef
chews135418513__chews
chewy165011903__chewy
chez184519023__chez
chow125820993__chow
clew95520573__clew
crew96122683__crew
each95530583each__
echo96615953e_ch_o
echoed125211153e_choed
echoer114011103e_choer
echoes114715523e_choes
echoey14397853e_choey
echos105216463e_chos
echt95722903e_ch_t
either94517423either
emcee9315943emc_ee
emceed1136283emceed
emcees1037813emcees
escape103811663escape
escaped12388853escaped
escapee113310463escapee
escaper11368843escaper
escapes113811673escapes
escar74011993esc_ar
escarp10449003escarp
escars83913133escars
eschars1237173eschars
escheats1346253escheats
eschewals1742623eschewals
eschewers1742883eschewers
eschewing1893503eschewing
escort84616483escort
escot75320083esc_ot
escoted1038183escoted
escots84211743escots
escrows1235803escrows
escudo943373escudo
eses45336103es__es
esker94412983es_ker
esne47018793es_ne_
esnes54817363es_nes
espied9359773espied
espies83716803espies
esses56422973es_ses
esteem838813esteem
ester54727713es_ter
esthete1047433esthete
etch95419143etch__
etchers123411293etchers
ether84518773e_ther
euchre11137663euchre
euchred13106163euchred
euchres1288663euchres
exceed1636173exceed
excel1437743exc_el
fescue1137493fescue_
fescues1236783fescues
fetched163710473fetched
fetcher153510393fetcher
fetches153413893fetches
fiche134616743fiche_
fiches145219533fiches
fitchew18276803fitchew
hew97642723___hew
inched124514483inched
incher114114033incher
inches114419673inches
ischia1136393ischia
isohel935483isohel
itched123812023itched
itches114916213itches
kenches163912273kenches
ketches164012193ketches
kuchen1536653kuchen
laches116528343laches
leached133715043leached
leacher124014843leacher
leaches123319343leaches
leched123716003leched
lecher113415853lecher
leches115421313leches
lechwe1435113lechwe
leeched13369503leeched
leeches123911933leeches
letched133912053letched
letches124015483letches
lichee114017973lichee
lichen114012743lichen
liches114724293liches
lychee143710893lychee
lyches144213613lyches
mache125925303mache_
maches134827233maches
menschen1543703menschen
mensches1536293mensches
merches144013763merches
meshed124415933mes_hed
meshes115019443mes_hes
miche126219243miche_
miched143913393miched
miches134320733miches
muches134718993muches
naches114622413naches
nephew1434113nephew
niche105016793niche_
niched125514063niched
niches114419143niches
ocher104516103_ocher
ouched124316933ouched
ouches114322183ouches
peached154315883peached
peacher144216073peacher
peaches144120053peaches
peched144915343peched
perched154713243perched
percher143313423percher
perches143717953perches
phew128417113__phew
pschent1437413pschent
pshaw13447513ps_haw
psyche1674293psyche_
psyched1843913psyched
psyches1755803psyches
rachet115028973rachet
reached134619083reached
reacher123718293reacher
reaches123423203reaches
rechews1537293rechews
rescue8313003rescue_
rescued10410043rescued
rescuer939033rescuer
rescues9312753rescues
resew84519503res__ew
reshes94124363res_hes
reshow123111433res_how
retched133814273retched
retches123318513retches
richen113812513richen
richer114015043richer
riches115022083riches
rochet115423003rochet
ruche104216763ruche_
ruched124314633ruched
ruches114819583ruches
sachem134012223sachem
sachet114725773sachet
schav1338313_schav
schema1388373_schema
scheme1379633_scheme
schlep1347093_schlep
schmo124510203_schmo
schul102510413_schul
schwa13426843_schwa
scow96021423_sc_ow
scree720031713_scree
screws115513893_screws
screwy14659463_screwy
secret8325063secret
seiche11811833seiche_
seiches12513813seiches
setscrew1341963setscrew
sew66247263_s__ew
shaw108132553_s_haw
she66837693_s_he_
shea76031573_s_hea
shed86536153_s_hed
shes75734353_s_hes
shewn115715703_s_hewn
shews115924713_s_hews
show106229193_s_how
shrew119720173_shrew
sinew84718923_sinew
skew116218763_s_kew
slew76228233_s_lew
smew95017733_s_mew
spew95421873_s_pew
stew77525463_s_tew
strew89220663_strew
tache106222373tache_
taches114224173taches
teacher123714833teacher
teaches122718353teaches
teched124014433teched
tenches123515523tenches
tetched133010773tetched
thew108226233__thew
tocher114014913tocher
tusche1136783tusche_
tusches1237903tusches
unscrew1245463unscrew
usher84517763us_her
vetches153411263vetches
welched16298833welched
welcher15319393welcher
welches153710313welches
wenched163910913wenched
wencher153811133wencher
wenches152914133wenches
whew137618783__whew
wiches144418753wiches
wyches17387913wyches

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.376475242.0
2DLD Change Limit1127162524.96622697.5
3Display Results2522520.0803150.0
 (SQL Overall)1786912525.42232956.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.