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

270 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
thatch143561(None) 
hatch135719591_hatch
thatchy1833301thatchy
batch124620102_batch
catch125120372_catch
cratch134110792cratch
dethatch1742752dethatch
hath105933912_hat_h
hitch134515472_hitch
hotch136214732_hotch
hutch135414092_hutch
klatch15445932klatch
latch104620462_latch
match125621102_match
natch105018222_natch
nuthatch1642082nuthatch
patch125221222_patch
ratch104221362_ratch
slatch114510532slatch
snatch114310602snatch
swatch14549282swatch
tach96132752t_a_ch
teach105221122tea_ch
thack144915172tha_ck
that75639322that__
thatched1735432thatched
thatcher1635662thatcher
thatches1637512thatches
twitch14406162twitch
watch135617062_watch
aitch105216163_aitch
anarch11310393anarch
arch98628443__arch
attach11118393atta_ch
bach116131393_ba_ch
bath95940083_bat_h
beach124623893bea_ch
bitch125017763_bitch
blanch133410853blanch
blotch13197143blotch
botch126717453_botch
brach126123303bra_ch
branch134014773branch
butch125416543_butch
bycatch1942063bycatch
catchy16559583_catchy
chalah143511663chalah
chaleh143711993chaleh
chance134617093chance
chancy164010863chancy
chat95546133chat__
chatchka22202893chatchka
chatchke22153883chatchke
chats105730093chat_s
chatty14419363chatty
chetah14399583chetah
cheth135013823chet_h
chinch163911233chinch
church1636483church
clach124617823cla_ch
clutch13367753clutch
coach125919453coa_ch
cranch133613533cranch
crotch133410083crotch
crutch13408243crutch
cultch13385953cultch
cutch125116193_cutch
datcha1266563_datcha
death94822523deat_h
detach12310413detach
ditch115015093_ditch
dutch114713823_dutch
each95530583_ea_ch
eath75735663_eat_h
eparch13258423eparch
etch95419143__etch
ethnarch1642413ethnarch
exarch18196173exarch
fetch134913473_fetch
fitch134816873_fitch
fletch14388193fletch
flitch14928173flitch
ghat86435283ghat__
ghats95818613ghat_s
glitch12286353glitch
grutch12285563grutch
hack135134543_ha_ck
hah910655223_ha__h
hance105424153_hance
harsh116418053_harsh
hash106936503_ha_sh
hat67289963_hat__
hatched163414463_hatched
hatchel153510753_hatchel
hatcher153314723_hatcher
hatches153420273_hatches
hatchet153317563_hatchet
hate78450173_hat_e
hated95734023_hated
hater85034753_hater
hates86742573_hates
hats76858253_hat_s
haugh125114053_haugh
haunch14377343_haunch
heath115724283heat_h
heth107028023_het_h
heuch135312333_heuch
hooch135813703_hooch
hootch14386413hootch
hunch136416213_hunch
inarch1139173inarch
itch95619173__itch
ketch144912023_ketch
khaph17395963kha_ph
khat116730723khat__
khats125316013khat_s
kheth15509753khet_h
klatsch1651683klatsch
kvetch1832993kvetch
laich105920713_laich
larch105919793_larch
lath76640383_lat_h
leach105422523lea_ch
letch105215803_letch
loach105116363loa_ch
loath84918603loat_h
mach116134483_ma_ch
march125622893_march
math95437453_mat_h
mutch125016173_mutch
nautch1144813nautch
neath86020283neat_h
notch105613323_notch
oath76132153_oat_h
orach105219233ora_ch
outcatch1544293outcatch
outmatch1544173outmatch
outwatch1643903outwatch
parch125123003_parch
patchy16509573_patchy
path99134913_pat_h
peach125422493pea_ch
phat95837863phat__
phatic133014413phatic
pitch125018413_pitch
planch133711443planch
poach124917863poa_ch
potlatch1543133potlatch
quaich2047693quaich
quitch2036413quitch
ranch105019793_ranch
rath76037663_rat_h
reach105123883rea_ch
rematch1436193rematch
repatch1435843repatch
retch104818303_retch
roach105717003roa_ch
rotch105815933_rotch
sauch104918773_sauch
scotch13207523scotch
scratch1446013scratch
scutch13247083scutch
search113312423search
shack145321753sha_ck
shah105627783sha__h
shantih13309643shantih
shat76456603shat__
shaugh13287433shaugh
sheath12412893sheat_h
sheuch14267043sheuch
sketch1535363sketch
smutch13205843smutch
snatchy15355293snatchy
snath86419803snat_h
snitch11357943snitch
stanch113812373stanch
starch113013203starch
stitch11419103stitch
strath93216373strat_h
stretch1236413stretch
swath115920383swat_h
switch14458913switch
tace65342513t_a_ce
tache106222373t_a_che
tachs105820933t_a_chs
tack106536293t_a_ck
taco67031353t_a_co
tact67349033t_a_ct
tacts76524123t_acts
talc66226813t_alc_
talcs74817183t_alcs
tat37690293t_at__
tatar56122063t_atar
tate44748603t_at_e
tater54138613t_ater
tates55444983t_ates
tats46858133t_at_s
tatty84720183t_atty
teat45963633teat__
teated74924023teated
teats55636813teat_s
tech95925443t__ech
teeth87315853teet_h
tench105620003t_ench
tenth85421833tent_h
tetchy1436003t_etchy
teth76327893t_et_h
teuch105214853t_euch
thacks154311923thacks
thae76825563tha__e
thairm1156963thairm
thaler94613103thaler
thalli958923thalli
than76128773tha__n
thane86122533tha_ne
thanes94918983thanes
thank125817803tha_nk
thanks134313133thanks
tharm105916643tha_rm
tharms115712243tharms
thatchers1744583thatchers
thatchier1743983thatchier
thatching1835143thatching
thaw107521313tha__w
thawed13458463thawed
thawer12489343thawer
thaws116515463tha_ws
thearchy1943443thearchy
theater104014253theater
theatre10358493theatre
theca103311453th_eca
thence112010843thence
theta83414573thet_a
thetas93011573thetas
thetic11412893thetic
thick145613353th_ick
thigh12410123th_igh
though139410783though
thrash12258363thrash
thresh12276863thresh
thrice114311573thrice
thrush12257483thrush
thwack1834213thwack
tilth85515363tilt_h
tooth88020183toot_h
torch107420933t_orch
touch106519393t_ouch
trace75829613tra_ce
track114823013tra_ck
tract75635713tra_ct
tracts85019073tracts
trance84718763trance
tranche123312223tranche
trash86119763tra_sh
trench114211613trench
troth85622203trot_h
truth85214153trut_h
twat75831513twat__
twats86616603twat_s
twitchy18393573twitchy
unhitch1543053unhitch
unlatch1245053unlatch
vetch134411843_vetch
whack174813023wha_ck
what105434073what__
whats117718993what_s
which163910083wh_ich
witch134517563_witch
wrath115715873wrat_h
wretch14326533wretch

Search took 7 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 Limit1127162705.65619928.6
3Display Results2702700.0803375.0
 (SQL Overall)1786912706.10929250.5
 
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.