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

204 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
attach1111839(None) 
attache12106691attache
attack12148151attack
aitch105216162ait_ch
attached14165702attached
attacher13125712attacher
attaches13137722attaches
attacks13126942attacks
attain6311752attain
attar56516692atta_r
attars64515312attars
attic75618352attic_
attics84413282attics
attract9511832attract
autarch1246622autarch
detach12310412detach
reattach1343742reattach
tach96132752__tach
teach105221122_teach
aah616252963a__a_h
abaca95118043a_baca
abaci94718843a_baci
aback134816173a_back
abash106016513a_bash
abbacy1536623abbacy
abroach1446213abroach
acta69524803acta__
alack114820063a_lack
almah106917253alma_h
alpaca1047383alpaca
altar55520643alta_r
altars64518153altars
amah98927493a_ma_h
amtrac10109133amtrac_
amtrack15107393amtrack
amtracs1198883amtracs
anarch11310393anarch
anlace82513923anlace
anta46839583anta__
antacid10311223antacid
antae56828293anta_e
antas55432033anta_s
antic75728863antic_
antick124814583antick
antics84621453antics
apace94718383a_pace
apache134210783a_pache
arch98628443a__rch
arrack121110253arrack
artal55525473arta_l
atap66722453a_ta_p
ataps76414833a_taps
ataxy1537313a_taxy
atlas55821583atla_s
atlatl637873atlatl
atma68121773atma__
atman75520143atma_n
atmans84413963atmans
atmas75721013atma_s
att35454653att___
attaboy1264303attaboy
attachers14134883attachers
attaching1545433attaching
attacked15125113attacked
attacker14144983attacker
attains7310983attains
attaint7313473attaint
attend7258973attend
attent62818323attent
attest62618613attest
attire62412383attire
attorn6310793attorn
attracts1047793attracts
attrit6315753attrit
attune637983attune
atwain937813atwain
autarchs1344993autarchs
autarchy1643603autarchy
avouch1434833avouch
awash116613163a_wash
ayah108022993a_ya_h
bach116131393__bach
batch124620103bat_ch
beach124623893_beach
bitch125017763bit_ch
bleach133611403bleach
botch126717453bot_ch
brach126123303_brach
breach134213723breach
broach133611113broach
butch125416543but_ch
caroach1488863caroach
catch125120373cat_ch
catface1436763catface
cattail939183cattail
cattalo938423cattalo
cattish12410723cattish
clach124617823_clach
coach125919453_coach
cratch134110793cratch
cutch125116193cut_ch
ditch115015093dit_ch
dutch114713823dut_ch
each95530583__each
etch95419143_et_ch
fatback1836923fatback
fattish1359263fattish
fetch134913473fet_ch
fetich1479693fetich
fitch134816873fit_ch
hatch135719593hat_ch
hatrack1638213hatrack
hitch134515473hit_ch
hotch136214733hot_ch
hutch135414093hut_ch
intact8314663intact
isotach1244953isotach
itch95619173_it_ch
ketch144912023ket_ch
kitsch1533353kitsch
klatch15445933klatch
latch104620463lat_ch
lattice938433lattice
leach105422523_leach
letch105215803let_ch
loach105116363_loach
lotah85315853lota_h
mach116134483__mach
match125621103mat_ch
matsah1138233matsa_h
mattock1535823mattock
matzah2035963matza_h
mutch125016173mut_ch
natch105018223nat_ch
nautch1144813naut_ch
notch105613323not_ch
orach105219233_orach
ottar54313993otta_r
ottars64112223ottars
ottava963683ottava
outact8317203outact
pataca10311193pataca
patch125221223pat_ch
peach125422493_peach
pitch125018413pit_ch
pleach134211243pleach
poach124917863_poach
potash1138273potash
potlach14106363potlach
preach133613923preach
putsch1334933putsch
ratch104221363rat_ch
rattail737803rattail
rattan63613603ratta_n
rattans73411953rattans
rattish10510823rattish
reach105123883_reach
reattack1444123reattack
retack122612823retack
retch104818303ret_ch
reteach1237413reteach
roach105717003_roach
rotch105815933rot_ch
slatch114510533slatch
snatch114310603snatch
stack114421693_stack
stanch113812373stanch
staph104314653_staph
starch113013203starch
stash84916973_stash
stench114111163stench
stich104117923_stich
stitch11419103stitch
stomach1436033stomach
strath93216373strath
sumach135310113sumach
swatch14549283swatch
tace65342513__tace
tache106222373__tache
tachs105820933__tachs
tack106536293__tack
taco67031353__taco
tact67349033__tact
tatami839193tatami
tatar56122063tata_r
tatars64619793tatars
tech95925443__tech
tench105620003_tench
teuch105214853_teuch
thack144915173_thack
thatch1435613_thatch
torch107420933_torch
touch106519393_touch
trace75829613_trace
track114823013_track
tract75635713_tract
trash86119763_trash
untack1239763untack
unteach1246143unteach
vetch134411843vet_ch
watch135617063wat_ch
wattage1186983wattage
wattape12135383wattape
witch134517563wit_ch

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 Limit1127162045.04622337.7
3Display Results2042040.0603400.0
 (SQL Overall)1786912045.48232596.0
 
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.