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

501 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
matcher14321428(None) 
batcher144414851batcher
catcher143115821catcher
hatcher153314721hatcher
marcher143912971marcher
matched153513961matched
matchers153012431matchers
matches143219781matches
patcher143515141patcher
watcher153113401watcher
archer115016242_archer
batched154114242batched
batchers153613272batchers
batches144019612batches
bather115322512bat_her
botcher143613222botcher
butcher143411162butcher
catchers153114062catchers
catches144320772catches
catchier15329862catchier
ditcher134012002ditcher
etcher113912942_etcher
father125116712fat_her
fetcher153510392fetcher
gather104115852gat_her
gaucher1337232gaucher
hatched163414462hatched
hatchel153510752hatchel
hatchers163113172hatchers
hatchery19326382hatchery
hatches153420272hatches
hatchet153317562hatchet
hitcher153712002hitcher
latched133914062latched
latches123320122latches
latchet123117902latchet
lather95124352lat_her
macer912126942ma_c_er
mache125925302ma_che_
maches134827232ma_ches
manche133515102manche_
manches143818622manches
manchet143317772manchet
marched153813402marched
marchen143312072marchen
marchers153710812marchers
marches143921172marches
masher114123202ma_sher
match125621102match__
matchup1643512matchup
mater74438862mat__er
matier84321522mat_ier
matter84325342mat_ter
maturer938972maturer
mither114218562mit_her
moocher143610672moocher
mother113718642mot_her
muncher143610372muncher
mutches143314282mutches
notcher123610932notcher
patched153514622patched
patchers153413302patchers
patches143320382patches
patchier15319662patchier
pitcher143813712pitcher
rancher123013632rancher
ratches123620462ratches
ratchet124218332ratchet
rather94319742rat_her
satchel123310302satchel
snatcher13167762snatcher
thatcher1635662thatcher
watched163012822watched
watchers163511792watchers
watches153017372watches
ache96829823_a_che_
ached119227833_a_ched
aches106132293_a_ches
achier113914263_a_chier
aether94213673_aether
aitches123014363aitches
anchor113911973_anchor
anther93715063_anther
arched125717323_arched
archers124414573_archers
archery15478063_archery
arches114822043_arches
atoner64817193_atoner
attacher13125713attacher
bached145519893ba_ched
baches135426943ba_ches
backer144525523ba_cker
basher115123813ba_sher
batch124620103batch__
bathe105822883bat_he_
bathed125518743bat_hed
bathers124720363bat_hers
bathes116524833bat_hes
batter84928873bat_ter
battier93515713battier
battler94113383battler
belcher143511493belcher
bencher144113483bencher
bitched153212923bitched
bitchen14349733bitchen
bitchery18236563bitchery
bitches144117063bitches
bitchier15307733bitchier
blancher15338633blancher
blather125314203blat_her
blucher143310223blucher
botched153611903botched
botchers153511543botchers
botchery18366763botchery
botches143716023botches
botchier15287143botchier
bother115218063bot_her
butchers153710183butchers
butchery18326253butchery
butches144315363butches
cache125122483ca_che_
cached145419203ca_ched
caches137926913ca_ches
cachet134526413ca_chet
cancer104220923canc_er
catch125120373catch__
catchup1644793catchup
catchy16559583catch_y
cater74840723cat__er
caterer92815943caterer
cattier93317073cattier
cither114616683cit_her
coacher143714123coacher
coucher144515853coucher
cratches153012543cratches
cutchery18265173cutchery
cutches143216463cutches
dacker134920753da_cker
dancer94817613danc_er
dasher104318983da_sher
datcha1266563datch_a
datchas1347423datchas
dater65332313dat__er
detacher1437543detacher
ditched143711903ditched
ditchers143610363ditchers
ditches133215713ditches
dither104417683dit_her
eater54639843eat__er
either94517423eit_her
etched123613703_etched
etchers123411293_etchers
etches114217763_etches
ether84518773_et_her
facer105525053fa_c_er
fancier123412063fancier
farcer115016083farc_er
farther1348343farther
fathers133916503fat_hers
fatter94523213fat_ter
fattier103513463fattier
feather133613503feat_her
fetched163710473fetched
fetchers16328863fetchers
fetches153413893fetches
filcher15377793filcher
fitchee152710783fitchee
fitches153516193fitches
fitchet153113563fitchet
fitchew18276803fitchew
fletcher16306663fletcher
gasher104320373ga_sher
gater64533653gat__er
gathers114315073gat_hers
gauche1238553gauche_
hacker154822693ha_cker
harsher13310363harsher
hatch135719593hatch__
hatcheck2244013hatcheck
hatchels16368673hatchels
hatchets163310383hatchets
hater85034753hat__er
hatter94724873hat_ter
heather133914853heat_her
hitched163312253hitched
hitchers16379993hitchers
hitches153616273hitches
hither124417253hit_her
hotched163610923hotched
hotches153814363hotches
hutched16359883hutched
hutches153613523hutches
incher114114033_incher
itched123812023_itched
itches114916213_itches
itchier12247673_itchier
ither84617603_it_her
jacker194417583ja_cker
kasher134915033ka_sher
ketches164012193ketches
kitchen16287683kitchen
klatches17157133klatches
kvetcher2052813kvetcher
lacer75833753la_c_er
laches116528343la_ches
lacier84020093la_cier
lacker125325623la_cker
lancer84319973lanc_er
larchen12479623larchen
larches124416443larches
lasher94824533la_sher
latch104620463latch__
latchets133410013latchets
latchkey2042913latchkey
later54843923lat__er
lathe85626713lat_he_
lathed104718453lat_hed
lathers104321883lat_hers
lathery133911123lat_hery
lathes95127493lat_hes
lathier10310833lathier
latter65027893lat_ter
laugher1136603laugher
launcher1365563launcher
leacher124014843leacher
leather103815783leat_her
lecher113415853_lecher
letched133912053letched
letches124015483letches
lither94520953lit_her
loather103711003loat_her
luncher123111413luncher
lurcher12338133lurcher
lyncher15366553lyncher
macaber1336163macaber
macchia1645893macchia
macchie1647193macchie
mace87345793ma_c_e_
maced108528693ma_c_ed
macers105321273ma_c_ers
maces97139963ma_c_es
mach116134483ma_ch__
machete14310883ma_chete
macho126120153ma_ch_o
machos135217493ma_chos
machree1438513ma_chree
machs125722563ma_ch_s
machzor2344263ma_chzor
macle96127003ma_cle_
macled116718113ma_cled
macles107023223ma_cles
madder103515593ma_dder
maihem1366213ma_ihem
mailer84724183ma_iler
maimer104514593ma_imer
maker114127813ma__ker
malmier113611953malmier
maltier93015483maltier
maltster1035303maltster
mammer94218863ma_mmer
mamzer19459833ma_mzer
manager103413583manager
manchets15269573manchets
manger94325003ma_nger
mangier104114063mangier
mangler103215643mangler
manlier92414023manlier
manner84020513ma_nner
manurer938583manurer
mapper124516093ma_pper
marbler113511673marbler
marcel103714853marc_el
march125622893march__
marchesa15346883marchesa
marchese15358913marchese
marchesi15337323marchesi
mariner93315993mariner
marker124420393ma_rker
markhor1635463markhor
marlier92614773marlier
marrer83716673ma_rrer
marrier93817523marrier
marshes123615373marshes
marshier1337593marshier
maser75029973ma__ser
mashed125325043ma_shed
mashers124621053ma_shers
mashes115030003ma_shes
masker124416103ma_sker
masquer18266463masquer
massier93615223massier
master84831343ma_ster
mastiche1547173mastiche_
mastiches1647333mastiches
matador1066253matador
matchbox2442623matchbox
matching163512393matching
matchless1644683matchless
matchmaker2352713matchmaker
matchmark2242913matchmark
matchups1743073matchups
mate65154223mat__e_
mated85537783mat__ed
maters85032393mat__ers
mates75251363mat__es
matey107022663mat__ey
math95437453mat_h__
maths105624023mat_h_s
matinee92415613matinee
matres84522233mat_res
matte75626843mat_te_
matted94521413mat_ted
matters94421753mat_ters
mattery123810713mat_tery
mattes85624533mat_tes
mature8313463mature_
matured10310033matured
maturers1037373maturers
matures9314303matures
mauger93813483ma_uger
mauler84416713ma_uler
maunder10328683maunder
mayhem1644923ma_yhem
mazer165722423ma__zer
mazier175013063ma_zier
meatier93214613meat_ier
mercer105214203merc_er
merches144013763merches
metamer1139613metamer
meter75130323met__er
metier83517693met_ier
miche126219243m_iche_
miched143913393m_iched
miches134320733m_iches
mincer104017363minc_er
mincier113512473mincier
miter75734793mit__er
miterer92511333miterer
mithers123516733mit_hers
mitier83620673mit_ier
mocker143315443m_ocker
mooched153910533mooched
moochers15369123moochers
mooches143714453mooches
mosher114719793m_osher
mothers123717623mot_hers
mothery153710513mot_hery
mothier121910213mothier
motlier92010583motlier
mottler94410343mottler
mouched153612593mouched
mouches143815963mouches
mouther123812813mouther
muches134718993m_uches
mucker143816393m_ucker
mulched15307763mulched
mulches143210673mulches
munched153411073munched
munchers15318773munchers
munches144215793munches
murther1237953murther
musher113820573m_usher
mutch125016173mutch__
muter74525543mut__er
mutter84418883mut_ter
mythier15125183mythier
naches114622413na_ches
natch105018223natch__
natter64420743nat_ter
nattier73614623nattier
nautches1336083nautches
nether94014163net_her
notched134210303notched
notchers13279423notchers
notches123513653notches
nother93815963not_her
oater55433733oat__er
ocher104516103__ocher
other84219103_ot_her
pacer96131613pa_c_er
pacier105018683pa_cier
packer144223403pa_cker
panther12611443panther
parched154013693parched
parches143720003parches
patch125221223patch__
patchy16509573patch_y
pater74740723pat__er
patter84628263pat_ter
patzer173111643pat_zer
peacher144216073peacher
percher143313423percher
pincher143812713pincher
pitched153512923pitched
pitchers153211483pitchers
pitches143617753pitches
pitchier15368273pitchier
poacher143912323poacher
pother113818853pot_her
puncher143311673puncher
racer75233023ra_c_er
rachet115028973ra_chet
racier85120973ra_cier
racker124824553ra_cker
ranched133113603ranched
ranchero13277423ranchero
ranchers133311793ranchers
ranches123620113ranches
rasher95024123ra_sher
ratch104221363ratch__
ratchets133110263ratchets
rater54943283rat__er
rathe85821923rat_he_
ratter64326313rat_ter
rattier74015593rattier
rattler74012743rattler
reacher123718293reacher
rematched1745223rematched
rematches1636653rematches
retched133814273retched
retches123318513retches
richer114015043_richer
rotche114311983rotche_
rotches123515703rotches
sachem134012223sa_chem
sachet114725773sa_chet
sacker125124843sa_cker
satchels13328163satchels
saucer84314103sauc_er
saucier9810283saucier
scratcher1635443scratcher
scutcher15176963scutcher
searcher13209103searcher
sketcher1735433sketcher
slatches131511523slatches
slather103816073slat_her
smacker153410583sma_cker
smasher123911023sma_sher
smatter93613333smat_ter
smoocher15205503smoocher
smother123510213smot_her
smutched16165923smutched
smutches15177273smutches
smutchier1643503smutchier
snatched14157633snatched
snatchers14146313snatchers
snatches131410713snatches
snatchier1455353snatchier
snitcher13157373snitcher
stacker134416263stacker
stancher13198813stancher
stitcher13168393stitcher
swatches16169963swatches
swather134213603swat_her
switcher16177683switcher
tache106222373ta_che_
taches114224173ta_ches
tacker124224503ta_cker
tater54138613tat__er
tatter64024573tat_ter
tattier74216243tattier
tattler73112213tattler
teacher123714833teacher
tetched133010773tetched
tetchier1336453tetchier
tether93716103tet_her
thatched1735433thatched
thatchers1744583thatchers
thatches1637513thatches
thatchier1743983thatchier
tither94920283tit_her
tocher114014913_tocher
tother94117143tot_her
toucher124814353toucher
twitcher16135343twitcher
unmatched1744203unmatched
vetches153411263vetches
voucher154110263voucher
wacker154920123wa_cker
washer124720393wa_sher
watch135617063watch__
watchcry2142363watchcry
watcheye19104273watcheye
watchmen1844753watchmen
water84733313wat__er
waterer103314073waterer
watter93221983wat_ter
weather133513223weat_her
welcher15319393welcher
wencher153811133wencher
wether123315393wet_her
wincher153410653wincher
witched163012193witched
witchery19236093witchery
witches152715793witches
witchier16307883witchier
wither124321353wit_her
wuther124511613wut_her
yachter1534913ya_chter
yatter94116213yat_ter
zither183813083zit_her

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 Filter1786911340270.420425454.8
2DLD Change Limit1340275016.83019623.3
3Display Results5015010.1862693.5
 (SQL Overall)1786915017.43624030.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.