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

359 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
detach1231041(None) 
attach11118392attach
beach124623892be_ach
deash95617242de_ash
death94822522de_ath
debauch15134422debauch
deface123113862deface
detached1537732detached
detacher1437542detacher
detaches1439652detaches
detail74516432detail
detain74617382detain
detect94217402detect
dethatch1742752dethatch
detick1339382detick
detract101414632detract
ditch115015092dit_ch
dutch114713822dut_ch
each95530582_e_ach
etch95419142_et_ch
fetch134913472fet_ch
fetich1479692fetich
ketch144912022ket_ch
leach105422522le_ach
letch105215802let_ch
peach125422492pe_ach
reach105123882re_ach
retack122612822retack
retch104818302ret_ch
reteach1237412reteach
tach96132752__tach
teach105221122te_ach
vetch134411842vet_ch
aitch105216163ait_ch
attache12106693attache
attack12148153attack
autarch1246623autarch
bach116131393__bach
batch124620103bat_ch
beachy164011253be_achy
beech124315503be_ech
belch124415503be_lch
bench125619503be_nch
beta66234133beta__
betake124512703betake
betas75528763beta_s
beth96629233bet__h
bitch125017763bit_ch
bleach133611403bleach
botch126717453bot_ch
brach126123303_brach
breach134213723breach
broach133611113broach
butch125416543but_ch
catch125120373cat_ch
cetane8315283cetane
chetah14399583cheta_h
clach124617823_clach
coach125919453_coach
cratch134110793cratch
cutch125116193cut_ch
dace76934923d__ace
dacha114812573d__acha
dah78148983d__a_h
dash87031633d__ash
data56026653data__
datary10310243datary
datcha1266563dat_cha
deacon9510423de_acon
dead65434243de_a_d
deads75726913de_ads
deaf85838403de_a_f
deair65817193de_air
deal56347413de_a_l
deals65435343de_als
dealt65234283de_alt
dean56039483de_a_n
deans66131393de_ans
dear55343603de_a_r
dears65736883de_ars
dearth104212513dearth
deary95826843de_ary
deaths105914443deaths
deathy134210233deathy
deave95022333de_ave
debacle1237443debacle
debag94212303deba_g
debags104211063debags
debar85517863deba_r
debark134210943debark
debars94218043debars
debase94014473debase
debate94419193debate
debouch15124253debouch
decade104216163decade
decaf114919443deca_f
decafs124010883decafs
decal85523233deca_l
decals93717713decals
decamp1338453decamp
decane93818873decane
decant93524223decant
decare93919153decare
decay114718483deca_y
decays124612913decays
deck115827753de__ck
deco76125973de__co
decoct11313783decoct
dedal75719023deda_l
dedans85915073dedans
deduce1079253deduce
deduct10610793deduct
defaced142910973defaced
defacer132810363defacer
defaces133213403defaces
defame123212433defame
defang1137753defang
defat95426693defa_t
defats105114553defats
defect124816173defect
degage92711383degage
degame102713183degame
degami10279013degami
degas75119163dega_s
deice84320033de_ice
deject164512843deject
dekare112811563dekare
delate73827753delate
delay94820633dela_y
delays104014053delays
delict94320333delict
delish105215613delish
delta66117773delta__
deltaic1037023deltaic
deltas74414823delta_s
deltic9312503deltic_
demand104314253demand
demarche1645533demarche
demark134211023demark
demast9517063demast
demic105119193demic_
denar65223293dena_r
denari710917353denari
denars74621433denars
denary105316863denary
dental74319173denta_l
dentals83915393dentals
dentate8315153dentate
depart94720563depart
depict113514793depict
depth114311853de_pth
derail74218813derail
derat65044083dera_t
derate74531233derate
derats74625063derats
deray95024183dera_y
derays105514253derays
desalt7518313desalt
desand84812633desand
despatch1643223despatch
destain8412083destain
detachers1536483detachers
detaching1637263detaching
details84214043details
detains83716093detains
detects104011093detects
detent73624483detent
deter65028043det_er
deters74724683deters
detest74122843detest
deticks1437353deticks
detour778193detour
detox13310953det_ox
detracts11138833detracts
detrain8412253detrain
deuce84517493de_uce
deva85720983deva__
devas96218883deva_s
device124512163device
dewan95718043dewa_n
dewans105215143dewans
dewar95817733dewa_r
dewars105117073dewars
dewax165510853dewa_x
didact10711203didact
dieback1646913dieback
dietary1158663dietary
diptych1842613diptych
distich13312173distich
dita56032523dita__
ditas65923673dita_s
doeth9411983doet__h
dotage82711613dotage
dotal64919623dota_l
dotard839053dotard
doth86225713dot__h
drachm1436493d_rachm
dreich12377723dreich
drench12369593drench
dunch115316263d_unch
eath75735663_e_ath
enact73525363_enact
epact94921533_epact
eparch13258423_eparch
epoch1248203_epoch
eta35834193_eta__
etape74413703_etape
etas46432273_eta_s
eth66630983_et__h
etic66123953_etic_
exact143516933_exact
exarch18196173_exarch
feta76528903feta__
fetal85623373feta_l
fetas85624403feta_s
fetish12310373fetish
fitch134816873fit_ch
fletch14388193flet_ch
gerah9315303gera_h
geta56627443geta__
getas65421483geta_s
hatch135719593hat_ch
heath115724283he_ath
heptarch1843563heptarch
heth107028023het__h
heuch135312333he_uch
hitch134515473hit_ch
hotch136214733hot_ch
hutch135414093hut_ch
intact8314663intact
isotach1244953isotach
itch95619173_it_ch
kench145513923ke_nch
kitsch1533353kitsch
klatch15445933klatch
kvetch1832993kvet_ch
latch104620463lat_ch
leachy14419733le_achy
leash85519213le_ash
lech96825443le__ch
leech104913213le_ech
legacy1256653legacy
loach105116363_loach
lotah85315853lota_h
mach116134483__mach
match125621103mat_ch
menace103216943menace
mensch13387093mensch
merch125417963me_rch
mesarch1445533mesarch
meta65932413meta__
metage93114453metage
metal75427383meta_l
metals84520883metals
metate82720533metate
meth95827843met__h
mutch125016173mut_ch
natch105018223nat_ch
neath86020283ne_ath
notch105613323not_ch
orach105219233_orach
outact8317203outact
pataca10311193pataca
patch125221223pat_ch
peace95026083pe_ace
peachy164510843pe_achy
pech116125453pe__ch
pentarch1544943pentarch
perch124518833pe_rch
petal76526893peta_l
petals84719813petals
petard95013803petard
pitch125018413pit_ch
pleach134211243pleach
poach124917863_poach
potash1138273potash
potlach14106363potlach
preach133613923preach
putsch1334933putsch
ratch104221363rat_ch
react74634333re_act
reattach1343743reattach
redact9419043redact
reface113616353reface
rehash1237433rehash
relace83122153relace
rematch1436193rematch
repack142412163repack
repatch1435843repatch
rerack122513163rerack
restack1339433restack
retacks132210713retacks
retag63618413reta_g
retags73414303retags
retail65522073retail
retain64523283retain
retake104718533retake
retape83917683retape
retard75018933retard
retax124517973reta_x
retouch1235853retouch
retrace91417343retrace
retrack131310723retrack
retract91318113retract
rewash1237673rewash
roach105717003_roach
rotch105815933rot_ch
search113312423search
selah8319613sela_h
serac75925203serac_
seracs84418573seracs
seraph114011163seraph
seta45637313seta__
setae56026223seta_e
setal56430903seta_l
setback1567143setback
sketch1535363sket_ch
slatch114510533slatch
snatch114310603snatch
stack114421693_stack
stanch113812373_stanch
staph104314653_staph
starch113013203_starch
stash84916973_stash
stench114111163stench
stich104117923_stich
sumach135310113sumach
swatch14549283swatch
tace65342513__tace
tache106222373__tache
tachs105820933__tachs
tack106536293__tack
taco67031353__taco
tact67349033__tact
tech95925443__tech
tenace82715693tenace
tench105620003te_nch
teraph11319093teraph
testacy1235963testacy
tetany959843tetany
tetchy1436003tet_chy
teth76327893tet__h
tetrarch13104783tetrarch
teuch105214853te_uch
thatch1435613thatch
untack1239763untack
unteach1246143unteach
watch135617063wat_ch
welch134411493we_lch
wench136214783we_nch
wetback1875613wetback
witch134517563wit_ch
wretch14326533wret_ch
xerarch1943843xerarch
yeah106725413ye_a_h
yecch15558093ye_cch
yech127220533ye__ch
zeta135121643zeta__
zetas145018163zeta_s

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.1401276364.3
2DLD Change Limit1127163597.17315713.9
3Display Results3593590.1103263.6
 (SQL Overall)1786913597.42324072.6
 
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.