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

332 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
latching14371202(None) 
batching163712091batching
catching163712771catching
hatching173312211hatching
lathing114315691lat_hing
letching143810261letching
matching163512391matching
patching163212751patching
watching173011171watching
aching126521972_a_ching
arching136216692_arching
baching156017752ba_ching
bathing134816242bat_hing
bitching163610622bitching
blanching17297092blanching
blotching1734962blotching
botching16359702botching
caching156317502ca_ching
clutching17154822clutching
ditching15349942ditching
etching134511842_etching
fetching17298412fetching
fletching18256142fletching
flitching18265342flitching
hatchings18225672hatchings
hatchling1844952hatchling
hitching173310522hitching
hotching17309312hotching
hutching17318642hutching
itching134011682_itching
katchina1745332katchina
lacing94626232la_c_ing
lacking143821542la_cking
lancing103314122lanc_ing
lashing114422892la_shing
latening9711492latening
lathings12469852lat_hings
laughing1335932laughing
launching1544782launching
leaching143012832leaching
leching134613652l_eching
leeching14318372leeching
loathing1247672loat_hing
lunching143110002lunching
lurching14277332lurching
lynching17336082lynching
marching164312192marching
notching14288582notching
parching164313052parching
pitching163411112pitching
ranching141712042ranching
retching143412172retching
snatching1536362snatching
thatching1835142thatching
unlatching1643152unlatching
witching173410632witching
aahing1019015763_a_ahing
acing87429153_a_c_ing
acting95920983_a_cting
ahing98928353_a__hing
altering91917113altering
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
blacking174213603bla_cking
blatting114111653blat_ting
bleaching17287093bleaching
blenching17276503blenching
branching17289263branching
bunching163410703bunching
cashing135022553ca_shing
catchier15329863catchier
catechin1546813catechin_
catechins1646643catechins
catering112019903catering
catling104819793cat_ling
catting103922643cat_ting
cinching163310223cinching
clacking173313493cla_cking
clashing143812193cla_shing
clenching17266303clenching
clinching17276123clinching
clothing14278783clot_hing
coaching164011963coaching
couching163213263couching
cranching17278733cranching
crutching17216073crutching
dancing113611563danc_ing
dashing125917893da_shing
dating85326483dat__ing
detaching1637263detaching
douching15349843douching
earthing12310323earthing
eating75134403eat__ing
eching126315563__eching
elating83423083elat__ing
etchings14396293_etchings
facing125321573fa_c_ing
faithing1537153faithing
fancying1735353fancying
farcing133514003farc_ing
farthing1538073farthing
fashing144918793fa_shing
fating105328673fat__ing
fatling113815683fat_ling
fatting113818703fat_ting
filching1736113filching
flacking184311793fla_cking
flashing153711553fla_shing
flatling123410013flat_ling
flatting123511253flat_ting
fleeching18305013fleeching
flenching18296703flenching
fletchings19282863fletchings
flinching18245833flinching
gashing125119233ga_shing
gating84826953gat__ing
glaceing1236533gla_ceing
glancing1247063glanc_ing
glunching16174083glunching
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
labeling11311643labeling
laboring112110143laboring
lacewing1435843lacewing
lacings105013653la_c_ings
lactating1239183lactating
ladening1078823ladening
lading84227123la__ding
ladling92813393la_dling
lagering102212313lagering
lagging103316733la_gging
laicising1245623laicising
laicizing2145713laicizing
lairing83715343la_iring
laking115027043la__king
lalling83519623la_lling
lambing123412413la_mbing
laming94528363la__ming
lamming123014583la_mming
lamping123116003la_mping
landing92819323la_nding
lapping124117023la_pping
lapsing103511163la_psing
lapwing13308263la_pwing
larchen12479623larchen_
larding92917873la_rding
larking123718253la_rking
lashings124412253la_shings
lashins103915153la_shins
lasing74727983la__sing
lassoing946383lassoing
lasting84725243la_sting
latch104620463latch___
latched133914063latch_ed
latches123320123latch_es
latchet123117903latch_et
latchets133410013latchets
latchkey2042913latchkey
latchstring17101963latchstring
lathering13912253lathering
lathi85417203lat_hi__
lathier10310833lat_hier
lathis95516173lat_hi_s
latina65621143lat__ina
latino64120473lat__ino
latrine7715123lat_rine
latticing1246063latticing
lattin64316223lat_tin_
lattins74115483lat_tins
lauding93211903la_uding
laughings1443483laughings
laving104623573la__ving
lavishing1644553lavishing
lawing104625283la__wing
layering122310353layering
laying104525703la__ying
lazing164821473la__zing
lazying2046673la_zying
leashing123310313leashing
letting83218533let_ting
lichting14268513l_ichting
licking144118283l_icking
litchi1137893litchi__
litchis1238373litchi_s
lithoing1236743lithoing
loathings1344213loat_hings
locking143718153l_ocking
locoing102810973l_ocoing
lotting82917753lot_ting
lucking143615833l_ucking
lushing114316113l_ushing
luting75221753lut__ing
lynchings18233503lynchings
machine14313493ma_chine
macing114221553ma_c_ing
mashing134422243ma_shing
mating94832913mat__ing
matting103620143mat_ting
maturing1139953maturing
miching152911803_miching
mooching16259063mooching
mouching163110583mouching
mulching16287103mulching
munching16299973munching
naething1236073naething
niching133612433_niching
nothing113511903not_hing
ouching134314903_ouching
pacing114522753pa_c_ing
packing164420723pa_cking
pashing135120513pa_shing
patchier15319663patchier
patchily1885813patchily
patining11312303patining
patting103722343pat_ting
peaching163613643peaching
peching154513903_peching
perching163711633perching
pinching163711053pinching
pithing134014053pit_hing
placing123815283pla_c_ing
plashing143311063pla_shing
plating103823073plat__ing
platting114813033plat_ting
plaything1843853plaything
pleaching17257083pleaching
poaching163510833poaching
pooching16328983pooching
potlatching1952113potlatching
pouching163210413pouching
psyching1934483psyching
punching163310123punching
racing95030533ra_c_ing
racking144323663ra_cking
ralphing1435413ralphing
ratcheting1643783ratcheting
rating74938703rat__ing
ratting83822363rat_ting
rattling92510873rattling
reaching143317203reaching
rematching1844913rematching
repatching1844993repatching
roaching143210433roaching
ruching133612933_ruching
sacking144122703sa_cking
sacring103115983sa_cring
sashing114621473sa_shing
sating74735453sat__ing
saucing10311003sauc_ing
scathing14269703scat_hing
scotching1735653scotching
scratching1844533scratching
scutching1735223scutching
searching1538343searching
sketching1935083sketching
slacking153914133sla_cking
slashing123713413sla_shing
slating83724653slat__ing
slatting94014233slat_ting
slouching15195723slouching
smutching1734853smutching
snitching1535913snitching
splotching1842863splotching
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
vatting113614853vat_ting
vetchling1843593vetchling
vouching17308233vouching
washing145119283wa_shing
watchdog1842243watchdog
watering122316313watering
wattling12258783wattling
wauchting1843473wauchting
welching17287363welching
wenching17328863wenching
winching17359903winching
witchings18325303witchings
withing143814493wit_hing
wrathing15248923wrat_hing
yachting1734933ya_chting
yacking174315683ya_cking

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.423422437.4
2DLD Change Limit1461623327.37319824.0
3Display Results3323320.1262634.9
 (SQL Overall)1786913327.92222556.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.