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

232 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
thatches163751(None) 
hatches153420271_hatches
thatched1735431thatched
thatcher1635661thatcher
thatchers1744581thatchers
batches144019612_batches
catches144320772_catches
chatchkes23174742chatchkes
cratches153012542cratches
dethatches1943192dethatches
hatched163414462_hatched
hatchel153510752_hatchel
hatchels16368672_hatchels
hatcher153314722_hatcher
hatchers163113172_hatchers
hatchet153317562_hatchet
hatchets163310382_hatchets
hitches153616272_hitches
hotches153814362_hotches
hutches153613522_hutches
klatches17157132klatches
latches123320122_latches
matches143219782_matches
nuthatches1842392nuthatches
patches143320382_patches
ratches123620462_ratches
slatches131511522slatches
snatches131410712snatches
swatches16169962swatches
taches114224172t_a_ches
teaches122718352tea_ches
thatch1435612thatch__
thatchier1743982thatchier
thatchiest1844162thatchiest
thatchy1833302thatch_y
tranches132915512tranches
twitches16156372twitches
watches153017372_watches
aches106132293__a_ches
aitches123014363_aitches
apaches143411833apa_ches
arches114822043__arches
attaches13137723atta_ches
baches135426943_ba_ches
batched154114243_batched
batcher144414853_batcher
batchers153613273_batchers
bathes116524833_bat_hes
beaches144120653bea_ches
bitches144117063_bitches
blanches153311603blanches
blotches1537433blotches
botches143716023_botches
braches144621223bra_ches
branches153613803branches
britches15278683britches
butches144315363_butches
bycatches2142683bycatches
caches137926913_ca_ches
catcher143115823_catcher
catchers153114063_catchers
chances145218093chanc_es
chancres15429363chancres
chatchka22202893chatchka
chatchkas23172783chatchkas
chatchke22153883chatchke
chinches18369363chinches
churches1846433churches
clutches15307923clutches
coaches144018693coa_ches
cranches153114543cranches
crotches153411303crotches
crutches15359593crutches
cultches15316533cultches
cutches143216463_cutches
datchas1347423_datchas
detaches1439653detaches
dethatched2042533dethatched
ditches133215713_ditches
etches114217763__etches
fetches153413893_fetches
fitches153516193_fitches
fletches16308853fletches
flitches16388463flitches
glitches14296653glitches
grutches14285853grutches
hances115621283_hanc_es
hashes125024803_ha_shes
hatch135719593_hatch__
hatcheck2244013_hatcheck
hatchecks2343593_hatchecks
hatchery19326383_hatchery
hates86742573_hat__es
haunches1656963_haunches
hitched163312253_hitched
hitcher153712003_hitcher
hitchers16379993_hitchers
hooches153812523_hooches
hootches1656973hootches
hotched163610923_hotched
hunches153913463_hunches
hutched16359883_hutched
inarches1358043inarches
itches114916213__itches
ketches164012193_ketches
klatsches1842223klatsches
kvetches2053583kvetches
laches116528343_la_ches
larches124416443_larches
latched133914063_latched
latchet123117903_latchet
latchets133410013_latchets
lathes95127493_lat_hes
leaches123319343lea_ches
letches124015483_letches
loaches123613983loa_ches
loathes103513243loat_hes
maches134827233_ma_ches
manches143818623_manches
marches143921173_marches
matched153513963_matched
matcher143214283_matcher
matchers153012433_matchers
mutches143314283_mutches
naches114622413_na_ches
nautches1336083nautches
notches123513653_notches
oraches124216473ora_ches
outcatches1743783outcatches
outmatches1763743outmatches
outwatches1843473outwatches
parches143720003_parches
patched153514623_patched
patcher143515143_patcher
patchers153413303_patchers
peaches144120053pea_ches
pitches143617753_pitches
planches153111863planches
poaches144416943poa_ches
potlatches17113323potlatches
quaiches2235343quaiches
quitches2236193quitches
ranches123620113_ranches
ratchet124218333_ratchet
ratchets133110263_ratchets
reaches123423203rea_ches
rematches1636653rematches
repatches1636713repatches
retches123318513_retches
rhachis1555693rha_chis
rhaphes1534703rha_phes
roaches123616213roa_ches
rotches123515703_rotches
satchel123310303_satchel
satchels13328163_satchels
scathes124515713scat_hes
schatchen1943853schatchen
schatchens2042683schatchens
scotches15179473scotches
scratches1647323scratches
scutches15168883scutches
searches132112903searches
sheathes14610193sheat_hes
sketches1746823sketches
smutches15177273smutches
snatched14157633snatched
snatcher13167763snatcher
snatchers14146313snatchers
snathes104816493snat_hes
snitches13148983snitches
spathes125116533spat_hes
stanches132312793stanches
starches131912913starches
stitches131410593stitches
stretches1438293stretches
swathes134115513swat_hes
switches16159133switches
taces76237803t_a_c_es
tache106222373t_a_che_
tachs105820933t_a_ch_s
takahes1436173t_akahes
tates55444983t_at__es
tatties74120343t_atties
tattles73616283t_attles
tchotchkes2451363tchotchkes
teacher123714833tea_cher
teachers133212393tea_chers
teatimes1039443teatimes
teethes103611653teet_hes
tenches123515523t_enches
tetched133010773t_etched
thacked173810203tha_cked
thacks154311923tha_c_ks
thanages12107623thanages
thanes94918983tha__nes
thatching1835143thatching
thatchings1942483thatchings
thearchies1844423thearchies
theatres11298633theat_res
thither13328103thit_her
thrashes1487653thrashes
threshes1437383threshes
thrushes1436523thrushes
tithes94720213t_it_hes
torches123715433t_orches
touches125118343t_ouches
traces85329933tra_c_es
trachea12311673tra_chea
tracheas13410273tra_cheas
trachles13311753tra_chles
trances93919643tranc_es
tranche123312223tranche_
trashes104119263tra_shes
trauchles1445493trauchles
trenches133512603trenches
troches123715343t_roches
tsatskes1242013tsatskes
tusches1237903t_usches
twattles1154383twattles
twitched17155033twitched
twitcher16135343twitcher
twitchers17134533twitchers
tythes12419703t_yt_hes
unhatched1844133unhatched
unhitches1743073unhitches
unlatches1444293unlatches
vetches153411263_vetches
watched163012823_watched
watcher153113403_watcher
watchers163511793_watchers
witches152715793_witches
wretches16257283wretches

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622327.72018932.9
3Display Results2322320.0932494.6
 (SQL Overall)1786912327.96922423.3
 
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.