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

269 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
klatch1544593(None) 
klatsch1651681klatsch
latch104620461_latch
slatch114510531slatch
batch124620102_batch
blanch133410852blanch
blotch13197142blotch
catch125120372_catch
clach124617822cla_ch
clutch13367752clutch
cratch134110792cratch
fletch14388192fletch
flitch14928172flitch
glitch12286352glitch
hatch135719592_hatch
ketch144912022k_etch
klatches17157132klatches
kvetch1832992kvetch
laich105920712_laich
larch105919792_larch
lath76640382_lat_h
letch105215802_letch
match125621102_match
natch105018222_natch
patch125221222_patch
planch133711442planch
ratch104221362_ratch
snatch114310602snatch
swatch14549282swatch
thatch1435602thatch
unlatch1245052unlatch
watch135617062_watch
aitch105216163_aitch
alack114820063ala_ck
alate55340323alat_e
alated75625143alated
alates64833963alates
anarch11310393anarch
arch98628443__arch
attach11118393attach
bach116131393_ba_ch
bath95940083_bat_h
beach124623893bea_ch
bitch125017763_bitch
black134719073bla_ck
blah98625063bla__h
blat66550953blat__
blate75933783blat_e
blats75132503blat_s
bleach133611403bleach
blench133710453blench
blotchy17293973blotchy
botch126717453_botch
brach126123303bra_ch
branch134014773branch
butch125416543_butch
bycatch1942063bycatch
catchy16559583_catchy
clachs133511323cla_chs
clack134720173cla_ck
clash106219033cla_sh
claucht1445583claucht
clench133910053clench
clinch133910353clinch
cloth105817543clot_h
clutchy17323893clutchy
coach125919453coa_ch
cranch133613533cranch
crotch133410083crotch
crutch13408243crutch
cultch13385953cultch
cutch125116193_cutch
datcha1266563_datcha
death94822523deat_h
detach12310413detach
ditch115015093_ditch
dutch114713823_dutch
each95530583_ea_ch
eath75735663_eat_h
elate55335883elat_e
elated74725823elated
elater64724203elater
elates65032363elates
eparch13258423eparch
etch95419143__etch
exarch18196173exarch
fetch134913473_fetch
fitch134816873_fitch
flack144519413fla_ck
flash115716213fla_sh
flat77147823flat__
flatcap1463653flatcap
flatcar1274613flatcar
flatly123110213flatly
flats86429743flat_s
flatus94310783flatus
fleech14367343fleech
flench144010813flench
flinch144010103flinch
flysch1732893flysch
glace87420153gla_ce
glance94312313glance
glitchy16283083glitchy
glunch1255353glunch
grutch12285563grutch
hath105933913_hat_h
heath115724283heat_h
hitch134515473_hitch
hootch14386403hootch
hotch136214723_hotch
hutch135414093_hutch
inarch1139163inarch
itch95619173__itch
kaliph1537873kaliph
kaph135815753k_a_ph
kat77468293k_at__
kata85626023k_at_a
katas95922093k_atas
kats85944333k_at_s
kench145513923k_ench
khaph17395963kha_ph
khat116730723khat__
khats125316013khat_s
kheth15509753khet_h
kiaugh1442813kiaugh
kirsch1532713kirsch
kith115826353k_it_h
kitsch1533353kitsch
klatsches1842223klatsches
klaxon1733853klaxon
klick105311433kl_ick
klutz1868853klut_z
klutzy2243003klutzy
knack104311043kna_ck
krater104014313krater
kvetchy2241803kvetchy
kwacha1832983kwa_cha
kyack13468263kya_ck
kyat116025523kyat__
kyats125012443kyat_s
lac510155823_la_c_
lace66848473_la_ce
lack105837683_la_ck
lacs66942483_la_cs
lacy95829633_la_cy
laic65931563_laic_
laichs115110893_laichs
laics76419253_laics
laigh95515923_laigh
laith85722103_laith
lakh114919953_la_kh
lance75126723_lance
lash76539653_la_sh
lat37593403_lat__
latched133914063_latched
latches123320123_latches
latchet123117903_latchet
late47560483_lat_e
lated65240673_lated
laten54328343_laten
later54843923_later
latex124717113_latex
lathe85626713_lathe
lathi85417203_lathi
laths86022403_laths
lathy115215063_lathy
lati46438273_lat_i
latish92416173_latish
latke94817093_latke
lats45962703_lat_s
latte55426303_latte
latu47934183_lat_u
laugh94414373_laugh
launch11368063_launch
leach105422523_leach
lech96825443_l_ech
leech104913213_leech
lich96230843_l_ich
litchi1137893_litchi
loach105116363_loach
loath84918603loat_h
loch95527133_l_och
lotah85315853_lotah
loth76132133_lot_h
lunch104917243_lunch
lurch104814633_lurch
lych126015763_l_ych
lynch13468983_lynch
mach116134473_ma_ch
march125622893_march
math95437443_mat_h
mutch125016173_mutch
nautch1144813nautch
neath86020283neat_h
notch105613323_notch
oath76132153_oat_h
orach105219233ora_ch
parch125123003_parch
patchy16509573_patchy
path99134913_pat_h
peach125422493pea_ch
pitch125018413_pitch
place94824613pla_ce
plack135017843pla_ck
plaice10311553plaice
planche14299753planche
plash104616563pla_sh
plat66048873plat__
platan83913693platan
plate74635113plat_e
plated95225773plated
platen84518203platen
plater84427693plater
plates85432243plates
plats75531373plat_s
platy105021663plat_y
platys11459853platys
pleach134211243pleach
plench134010813plench
poach124917863poa_ch
potlatch1543133potlatch
quaich2047693quaich
quitch2036413quitch
ranch105019793_ranch
rath76037663_rat_h
reach105123883rea_ch
rematch1436193rematch
repatch1435843repatch
retch104818303_retch
roach105717003roa_ch
rotch105815933_rotch
sauch104918773_sauch
scotch13207513scotch
scratch1446013scratch
scutch13247083scutch
search113312423search
sketch1535353sketch
slack115021763sla_ck
slash84719683sla_sh
slat46959023slat__
slatches131511523slatches
slate55438283slat_e
slated75028313slated
slater64429183slater
slates64934063slates
slatey95417063slatey
slats55436903slat_s
slaty86523153slat_y
sloth85019443slot_h
slouch11438523slouch
smutch13205843smutch
snatchy15355293snatchy
snath86419803snat_h
snitch11357943snitch
splotch1442843splotch
stanch113812373stanch
starch113013203starch
stitch11419103stitch
swath115920383swat_h
switch14458913switch
tach96132753_ta_ch
teach105221123tea_ch
thatchy1833303thatchy
twitch14406163twitch
vetch134411843_vetch
witch134517563_witch
wrath115715873wrat_h
wretch14326533wretch
zlotych2441413zlotych

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 Limit1127162697.50015028.8
3Display Results2692690.0763539.5
 (SQL Overall)1786912697.71623158.5
 
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.