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 “hotching” 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
hotching1730931(None) 
botching16359701botching
hatching173312211hatching
hitching173310521hitching
hutching17318641hutching
notching14288581notching
batching163712092batching
bitching163610622bitching
blotching1734962blotching
catching163712772catching
coaching164011962coaching
couching163213262couching
ditching15349942ditching
douching15349842douching
etching134511842_etching
fetching17298412fetching
hatchings18225672hatchings
hatchling1844952hatchling
hocking173417242ho_cking
hoicking1836052hoicking
honchoing1844872honchoing
hotting113116522hot_ting
hunching17309112hunching
itching134011682_itching
latching143712022latching
letching143810262letching
matching163512392matching
mooching16259062mooching
mouching163110582mouching
nothing113511902not_hing
ouching134314902_ouching
patching163212752patching
pitching163411112pitching
poaching163510832poaching
pooching16328982pooching
pouching163210412pouching
retching143412172retching
roaching143210432roaching
scotching1735652scotching
thatching1835142thatching
torching142510082torching
touching143211342touching
vouching17308232vouching
watching173011172watching
witching173410632witching
aching126521973__aching
arching136216693_arching
attaching1545433attaching
avouching1843273avouching
baching156017753_baching
bathing134816243bat_hing
beaching164114143beaching
belching16349153belching
benching163411343benching
birching16328463birching
botchier15287143botchier
botchily1864373botchily
bottling11279143bottling
broaching17287663broaching
bunching163410703bunching
caching156317503_caching
chocking204011013cho_cking
churching2055083churching
cinching163310223cinching
clothing14278783clot_hing
clutching17154823clutching
coacting133412703coacting
cochin131313203co_chin_
cochins141413103co_chins
cocking163619983co_cking
coshing134316433co_shing
coting94629253cot__ing
couchings17285763couchings
coughing15309213coughing
crouching1746383crouching
crutching17216073crutching
detaching1637263detaching
docking153615013do_cking
doting84821913dot__ing
dotting93314483dot_ting
eching126315563__eching
etchings14396293_etchings
filching1736113filching
fletching18256143fletching
flitching18265343flitching
forcing134013753forc_ing
frothing15208533frot_hing
grouching1644943grouching
grutching16224373grutching
hacking173720613h_acking
hashing145020163h_ashing
hatcheling1943693hatcheling
hatchlings1943033hatchlings
hating104929713hat__ing
hatting113920233hat_ting
hitting113017273hit_ting
hoarding13288643hoarding
hoaxing18307763ho_axing
hobbing152811123ho_bbing
hobbling16227583hobbling
hoboing13309453ho_boing
hocusing1446583hocusing
hoeing104117023ho__eing
hogging133112803ho_gging
hogtieing1442863hogtieing
hogtying1633553hogtying
hoising113414413ho_ising
hoisting123610903hoisting
hoking144419513ho__king
holding123514283ho_lding
holing104025073ho__ling
holking153512313ho_lking
hollaing12167103hollaing
holloing12148823holloing
homaging1536613homaging
homering141512073homering
homing123718383ho__ming
hondling132210013hondling
honeying1537673honeying
hongiing1335603hongiing
honing103421503ho__ning
honking153414793ho_nking
honoring12310473honoring
hoochie1537803hoochi_e
hoochies1639603hoochies
hooding123815203ho_oding
hoofing143912553ho_ofing
hooking153716693ho_oking
hooping133615703ho_oping
hoorahing1644913hoorahing
hooting113919883ho_oting
hoping123719743ho__ping
hopping154115273ho_pping
hoppling16206763hoppling
hording123517053ho_rding
horning113015003ho_rning
horsing113215583ho_rsing
hoseying1537193hoseying
hosing103421103ho__sing
hosteling1337893hosteling
hosting114318383ho_sting
hotch136214733hotch___
hotched163610923hotch_ed
hotches153814363hotch_es
hotchpot1844123hotchpot
hotline10712353hot_line
hotlink1476763hot_link
hounding132610053hounding
housing113316523ho_using
hoveling15189593hoveling
hovering151911143hovering
howdying1933713howdying
howking183610313ho_wking
howling143413163ho_wling
humphing1935163humphing
hushing144514473h_ushing
hutting113016033hut_ting
inching134414323_inching
itchings14386193_itchings
joshing18519413jo_shing
jotting152912773jot_ting
katchina1745333katchina
kithing153411553kit_hing
kotowing1634013kotowing
kvetching2242903kvetching
kything18285523kyt_hing
lathing114315693lat_hing
leaching143012833leaching
leching134613653_leching
leeching14318373leeching
loathing1247673loathing
locking143718153lo_cking
locoing102810973lo_coing
lotting82917753lot_ting
lunching143110003lunching
lurching14277333lurching
lynching17336083lynching
marching164312193marching
miching152911803_miching
mocking163614453mo_cking
morphing1637553morphing
moshing134214883mo_shing
motiving1437163motiving
motoring11410953motoring
mottling11197753mottling
mouthing142810243mouthing
mulching16287103mulching
munching16299973munching
niching133612433_niching
nocking143615113no_cking
noncling11310763noncling
northing12199063northing
noshing114612773no_shing
notating92513343notating
nothings12266683not_hings
noticing1139453noticing
noting74120153not__ing
ochring13156673_o_chring
ohing96018813_o__hing
oohing104412933_o_ohing
parching164313053parching
peaching163613643peaching
peching154513903_peching
perching163711633perching
photoing1439073phot_oing
pinching163711053pinching
pithing134014053pit_hing
pocking163916763po_cking
poncing122913583ponc_ing
poohing133112323po_ohing
potting103720893pot_ting
psyching1934483psyching
punching163310123punching
ranching141712043ranching
reaching143317203reaching
rocking143619633ro_cking
rotating92614553rotating
rotting82919683rot_ting
roughing13278343roughing
ruching133612933_ruching
scooching1735073scooching
scootching1843363scootching
scorching1735633scorching
scutching1735223scutching
shocking184311543sho_cking
shotting123012383shot_ting
sketching1935083sketching
slouching15195723slouching
smooching1734883smooching
smutching1734853smutching
snatching1536363snatching
snitching1535913snitching
socking143518603so_cking
soochong14104373soochong
soothing12269973soothing
souchong1484513souchong
soughing13259733soughing
southing122811823southing
splotching1842863splotching
stitching1547103stitching
stocking152912503stocking
switching1835703switching
synching17227713synching
teaching143612603teaching
thatchings1942483thatchings
thing96622983__t_hing
tithing113513893tit_hing
toothing12278863toothing
totaling9610303totaling
toting74123793tot__ing
totting82816843tot_ting
toughing13278553toughing
trothing122410843trot_hing
twitching1834243twitching
tything14316573tyt_hing
unhitching1942843unhitching
vetchling1843593vetchling
voicing13279083voic_ing
voting103916033vot__ing
welching17287363welching
wenching17328863wenching
whooshing1943213whooshing
winching17359903winching
witchings18325303witchings
withing143814493wit_hing
wooshing1536683wooshing
worthing15178053worthing
wotting112913843wot_ting
yocking173712373yo_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.450397091.1
2DLD Change Limit1461622698.08018089.4
3Display Results2692690.1102445.5
 (SQL Overall)1786912698.64020681.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.