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

260 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
wrench1443935(None) 
drench12369591drench
french143511211french
trench114211611trench
wench136214781w_ench
wretch14326531wretch
bench125619502_bench
blench133710452blench
branch134014772branch
breach134213722breach
breech13348262breech
brunch13329352brunch
clench133910052clench
cranch133613532cranch
crunch13349502crunch
dreich12377722dreich
flench144010812flench
grinch1238472grinch
kench145513922_kench
plench134010812plench
preach133613922preach
quench2036632quench
ranch105019792_ranch
reach105123882_reach
retch104818302_retch
stench114111162stench
tench105620002_tench
welch134411492w_elch
whence14187922whence
winch135016662w_inch
wreath124111192wreath
wreck144611042wre_ck
wren78221682wren__
wrenched17748132wrenched
wrencher16287782wrencher
wrenches163210232wrenches
wrens85016242wren_s
agency1237033agency
arch98628443ar__ch
ardency1346483ardency
areca75618633are_ca
areic73219393areic_
arena55323813aren_a
arenas65021993arenas
arene55329413aren_e
arenes64928393arenes
beach124623893_beach
bedrench1644153bedrench
beech124315503_beech
belch124415503_belch
blanch133410853blanch
bleach133611403bleach
brach126123303br_ach
branchy17357913branchy
breath113916263breath
bren65629563bren__
brens75823363bren_s
brent75734133bren_t
brents84717273brents
broach133611113broach
bronc91714343bronc_
bronchi14176313bronchi
broncho14206463broncho
bronco10179493bronco
broncs101611153broncs
brooch13368443brooch
bunch125118603_bunch
chinch163911223chinch
cinch124516243_cinch
clinch133910353clinch
conch124620073_conch
cratch134110793cratch
craunch1464443craunch
creche13310763cre_che
creesh11328333creesh
crenel84213063crenel
crotch133410083crotch
crouch133910203crouch
crunchy17324763crunchy
crutch13408243crutch
dreck124812803dre_ck
dreigh11246443dreigh
drenched15247913drenched
drencher14257213drencher
drenches14309803drenches
dunch115316263_dunch
each95530583__each
elenchi1244713elenchi
entrench13115723entrench
erect74129333ere_ct
erenow937373erenow
etch95419143__etch
fence105319913_fence
fetch134913473_fetch
finch135416973_finch
fleech14367343fleech
fletch14388193fletch
flinch144010103flinch
franc104615413franc_
francs114112193francs
frena85915273fren_a
frenched17299433frenched
frenches163311633frenches
frenum1188803frenum
frenzy2135883frenzy
fresco1136473fresco
fresh115012203fre_sh
glunch1255353glunch
greenth11116723greenth
grouch12318473grouch
grutch12285563grutch
haunch14377343haunch
hence104920043_hence
heuch135312333_heuch
hunch136416213_hunch
inch95420823__inch
intrench1396593intrench
irenic8311103irenic
irenics937833irenics
ketch144912023_ketch
kvetch1832993kvetch
launch11368063launch
leach105422523_leach
lech96825443_le_ch
leech104913213_leech
letch105215803_letch
lunch104917243_lunch
lynch13468983_lynch
mensch13387083_mensch
mensh105413553_mensh
merch125417963_merch
munch124917103_munch
orach105219233or_ach
painch133511323painch
paunch13369853paunch
peach125422493_peach
pech116125453_pe_ch
pence94924453_pence
perch124518833_perch
pinch125619303_pinch
pinwrench1951663pinwrench
planch133711443planch
pleach134211243pleach
prance104318573prance
preachy17307313preachy
preact103220393preact
prelunch1543433prelunch
prepunch1743643prepunch
prince104114763prince
punch125118423_punch
rance75028513_rance
rancho114310853_rancho
ratch104221363_ratch
raunch11358433raunch
react74634333_react
rec55645463_re_c_
recce9514563_recce
reck106130563_re_ck
recs65734183_re_cs
reecho11318653_reecho
reechy14367823_reechy
renal55929503_renal
rend56136573_ren_d
rends65129953_rends
renew83917513_renew
renig64518913_renig
renin54830033_renin
rent46661243_ren_t
rente54733783_rente
rents55935183_rents
resh76523453_re_sh
retrench1346283retrench
rich97025543_r_ich
roach105717003_roach
rotch105815933_rotch
screech1435213screech
scrunch1444033scrunch
sheuch14267043sheuch
sketch1535353sketch
speech1347563speech
spence103813793spence
stanch113812373stanch
stenchy15256213stenchy
stretch1236413stretch
synch135011793_synch
teach105221123_teach
tech95925443_te_ch
tenth85421833_tenth
teuch105214853_teuch
thence112010843thence
trance84718763trance
tranche123312223tranche
trefah1235093trefah
trenched14289853trenched
trencher13279313trencher
trenches133512603trenches
trend64817453tren_d
trends75513543trends
trendy10469603trendy
upreach1444693upreach
ureic74514463ureic_
urgency1345663urgency
vetch134411843_vetch
watch135617063w_atch
wecht13415443w_e_cht
ween75835463ween__
weened104013733weened
weenie92612023weenie
weens85224053ween_s
weensy12416823weensy
weeny115316163ween_y
weigh125412513w_eigh
welsh113110363w_elsh
wen66249603w_en__
wenched163910913w_enched
wencher153811133w_encher
wenches152914133w_enches
wend85330453w_en_d
wends95822813w_ends
wenny114412463w_enny
wens76337933w_en_s
went76051873w_en_t
when105723043when__
whenas124610463whenas
whens114618763when_s
which163910083w_hich
wich125724743w__ich
wiener94513543wiener
wienie9229973wienie
wince105220883w_ince
witch134517563w_itch
workbench2361453workbench
wrack145413883wr_ack
wraith1258603wraith
wrang94716113wran_g
wrangs104611913wrangs
wrath115715873wr_ath
wreak125513273wre_ak
wreaks134711113wreaks
wreathe13339053wreathe
wreaths13338373wreaths
wreathy16326063wreathy
wrecks15418883wrecks
wrenchers17256333wrenchers
wrenching18276273wrenching
wrest84925433wre_st
wrests95313083wrests
wretched17276533wretched
wretches16257283wretches
wrick144013393wr_ick
wring95920713wrin_g
wrings104012973wrings
wrong94712323wron_g
wrongs10338933wrongs
wroth116815883wr_oth
wrung9549803wrun_g
wryneck1941383wryneck
wych154011883w__ych
yecch15558093_yecch
yech127220533_ye_ch

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 Filter1786911127160.186960704.3
2DLD Change Limit1127162606.94016241.5
3Display Results2602600.0932795.7
 (SQL Overall)1786912607.21924752.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.