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

317 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
matching16351239(None) 
batching163712091batching
catching163712771catching
hatching173312211hatching
latching143712021latching
marching164312191marching
patching163212751patching
watching173011171watching
aching126521972_a_ching
arching136216692_arching
baching156017752ba_ching
bathing134816242bat_hing
bitching163610622bitching
botching16359702botching
caching156317502ca_ching
ditching15349942ditching
etching134511842_etching
fetching17298412fetching
hatchings18225672hatchings
hatchling1844952hatchling
hitching173310522hitching
hotching17309312hotching
hutching17318642hutching
itching134011682_itching
katchina1745332katchina
lathing114315692lat_hing
letching143810262letching
machine14313492ma_chine
macing114221552ma_c_ing
mashing134422242ma_shing
mating94832912mat__ing
matting103620142mat_ting
maturing1139962maturing
miching152911802m_iching
mooching16259062mooching
mouching163110582mouching
mulching16287102mulching
munching16299972munching
notching14288582notching
parching164313052parching
pitching163411112pitching
ranching141712042ranching
rematching1844912rematching
retching143412172retching
smutching1734852smutching
snatching1536362snatching
thatching1835142thatching
witching173410632witching
aahing1019015763_a_ahing
acing87429153_a_c_ing
acting95920983_a_cting
ahing98928353_a__hing
archine125817053_archine
archings14499863_archings
arcing95819643_arc_ing
arcking145811963_arcking
ashing107824093_a_shing
atoning83514873_atoning
attaching1545433attaching
backing165523443ba_cking
bashing135422583ba_shing
batiking1537503batiking
bating95132253bat__ing
batting104422273bat_ting
battling113110493battling
batwing13509813bat_wing
beaching164114143beaching
belching16349153belching
benching163411343benching
birching16328463birching
blanching17297093blanching
blotching1734963blotching
branching17289263branching
bunching163410703bunching
cashing135022553ca_shing
catchier15329863catchier
catechin1546813catechin_
catechins1646643catechins
catering112019913catering
catling104819793cat_ling
catting103922643cat_ting
cinching163310223cinching
clutching17154823clutching
coaching164011963coaching
couching163213263couching
cranching17278733cranching
crutching17216073crutching
dancing113611563danc_ing
dashing125917893da_shing
dating85326483dat__ing
detaching1637263detaching
douching15349843douching
earthing12310333earthing
eating75134403eat__ing
eching126315563__eching
etchings14396293_etchings
facing125321573fa_c_ing
faithing1537153faithing
fancying1735353fancying
farcing133514003farc_ing
farthing1538073farthing
fashing144918793fa_shing
fating105328673fat__ing
fatling113815683fat_ling
fatting113818703fat_ting
filching1736113filching
fletching18256143fletching
flitching18265343flitching
gashing125119233ga_shing
gating84826953gat__ing
grutching16224373grutching
hacking173720613ha_cking
hashing145020163ha_shing
hatcheling1943693hatcheling
hatchlings1943033hatchlings
hating104929713hat__ing
hatting113920233hat_ting
hunching17309113hunching
inarching1546343inarching
inching134414323_inching
itchings14386193_itchings
jacking214515263ja_cking
kachina1637663ka_china
katchinas1843923katchinas
katcina1345153katc_ina
kithing153411553kit_hing
kvetching2242903kvetching
kything18285523kyt_hing
lacing94626233la_c_ing
lacking143821543la_cking
lancing103314123lanc_ing
lashing114422893la_shing
latening9711493latening
lathings12469853lat_hings
laughing1335933laughing
launching1544783launching
leaching143012833leaching
leching134613653_leching
leeching14318373leeching
loathing1247673loat_hing
lunching143110003lunching
lurching14277333lurching
lynching17336083lynching
macchia1645893macchi_a
macchie1647193macchi_e
machined1637303ma_chined
machines15312893ma_chines
machining1746933ma_chining
mackling172710063mackling
maculing13219583maculing
madding123711993ma_dding
magicking19113543magicking
mailing102923343ma_iling
maiming122912723ma_iming
majoring1836363majoring
making134823853ma__king
malihini1344823malihini
malling103623663ma_lling
malting103219083ma_lting
mamboing1535973mamboing
manacling1446283manacling
managing1239093managing
mangling122312623mangling
manning103616383ma_nning
mantling112012613mantling
manuring1139223manuring
mapping143413993ma_pping
marbling13179883marbling
marchen143312073marchen_
marking144020133ma_rking
marling103322773ma_rling
marring103319553ma_rring
marrying14157233marrying
marting103325013ma_rting
martyring1535783martyring
masking145116613ma_sking
masoning1139763masoning
massing104318023ma_ssing
mastering122315313mastering
masting104325823ma_sting
match125621103match___
matchbox2442623matchbox
matched153513963match_ed
matcher143214283match_er
matchers153012433matchers
matches143219783match_es
matchmaking2552973matchmaking
matchup1643513match_up
matchups1743073matchups
matin75132853mat__in_
matings104516213mat__ings
matins84527783mat__ins
mattering122314063mattering
mattin84416633mat_tin_
mattings11369673mat_tings
mattins93316143mat_tins
mauling103315683ma_uling
mawing124020803ma__wing
maxing164817073ma__xing
maying124421153ma__ying
mazing184418973ma__zing
meshing134513813m_eshing
metaling111613723metaling
metering112915633metering
meting94320593met__ing
metring103215293met_ring
milchig1543653milchi_g
mincing123314333minc_ing
miscuing1338733miscuing
mismatching21123403mismatching
mispatching21133433mispatching
mitering113015403mitering
mitring103514143mit_ring
moating104218153moat__ing
mocking163614453m_ocking
morphing1637553morphing
moshing134214883m_oshing
motiving1437163motiving
motoring11410953motoring
mottling11197753mottling
mouthing142810243mouthing
mucking163213823m_ucking
mulcting13246983mulcting
muscling1337853muscling
mushing134217633m_ushing
mutating112211753mutating
mutchkin1943023mutchkin_
mutchkins2042913mutchkins
muting93921523mut__ing
mutining11310493mutining
naething1236073naething
niching133612433_niching
nothing113511903not_hing
ouching134314903_ouching
outmatching1943333outmatching
pacing114522753pa_c_ing
packing164420723pa_cking
pashing135120513pa_shing
patchier15319663patchier
patchily1885813patchily
patining11312303patining
patting103722343pat_ting
peaching163613643peaching
peching154513903_peching
perching163711633perching
pinching163711053pinching
pithing134014053pit_hing
poaching163510833poaching
pooching16328983pooching
pouching163210413pouching
psyching1934483psyching
punching163310123punching
racing95030533ra_c_ing
racking144323663ra_cking
ralphing1435413ralphing
ratcheting1643783ratcheting
rating74938703rat__ing
ratting83822363rat_ting
rattling92510873rattling
reaching143317203reaching
repatching1844993repatching
roaching143210433roaching
ruching133612933_ruching
sacking144122703sa_cking
sacring103115983sa_cring
sashing114621473sa_shing
sating74735453sat__ing
saucing10311003sauc_ing
scathing14269703scat_hing
scotching1735653scotching
scratching1844533scratching
scutching1735223scutching
searching1538343searching
sketching1935083sketching
smacking173510763sma_cking
smashing143310243sma_shing
smirching1744393smirching
smooching1734883smooching
snitching1535913snitching
stacking154215083stacking
stanching1538083stanching
starching1538593starching
stashing123511583stashing
stitching1547103stitching
swathing15248713swat_hing
switching1835703switching
synching17227713synching
tacking144421483ta_cking
talcing103111633talc_ing
talcking1567083talcking
tatting84019523tat_ting
tattling9259473tattling
teaching143612603teaching
thatchings1942483thatchings
thing96622983__t_hing
tithing113513893tit_hing
torching142510083torching
touching143211343touching
twitching1834243twitching
tything14316573tyt_hing
unlatching1643153unlatching
vatting113614853vat_ting
vetchling1843593vetchling
vouching17308233vouching
washing145119283wa_shing
watchdog1842243watchdog
watering122316323watering
wattling12258783wattling
wauchting1843473wauchting
welching17287363welching
wenching17328863wenching
winching17359903winching
witchings18325303witchings
withing143814493wit_hing
wrathing15248923wrat_hing
yachting1734933ya_chting
yacking174315683ya_cking

Search took 9 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.483369960.7
2DLD Change Limit1461623177.79618748.3
3Display Results3173170.1232577.2
 (SQL Overall)1786913178.40221267.7
 
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.