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

299 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
botching1635970(None) 
batching163712091batching
bitching163610621bitching
blotching1734961blotching
hotching17309311hotching
notching14288581notching
baching156017752b_aching
bathing134816242bat_hing
beaching164114142beaching
belching16349152belching
benching163411342benching
birching16328462birching
botchier15287142botchier
botchily1864372botchily
bottling11279142bottling
broaching17287662broaching
bunching163410702bunching
catching163712772catching
coaching164011962coaching
couching163213262couching
ditching15349942ditching
douching15349842douching
etching134511842_etching
fetching17298412fetching
hatching173312212hatching
hitching173310522hitching
hutching17318642hutching
itching134011682_itching
latching143712022latching
letching143810262letching
matching163512392matching
mooching16259062mooching
mouching163110582mouching
nothing113511902not_hing
ouching134314902_ouching
patching163212752patching
pitching163411112pitching
poaching163510832poaching
pooching16328982pooching
pouching163210412pouching
retching143412172retching
roaching143210432roaching
scotching1735652scotching
torching142510082torching
touching143211342touching
vouching17308232vouching
watching173011172watching
witching173410632witching
aching126521973__aching
arching136216693_arching
attaching1545433attaching
avouching1843273avouching
backing165523443b_acking
bashing135422583b_ashing
batiking1537503batiking
bating95132253bat__ing
batting104422273bat_ting
battling113110493battling
batwing13509813bat_wing
becking164416073b_ecking
berthing14209593berthing
betaking153010153betaking
bethink1677203bet_hink
betiding1239913betiding
betting103921403bet_ting
bewitching2162773bewitching
birthing14338433birthing
bitchen14349733bitchen_
bitchier15307733bitchier
bitchily1844533bitchily
bitewing1435293bitewing
biting95321823bit__ing
bitting103717293bit_ting
blacking174213603blacking
blanching17297093blanching
bleaching17287093bleaching
blenching17276503blenching
blocking174510573blocking
blotchier1643213blotchier
blotchily1942683blotchily
blotting113910433blot_ting
blushing14339333blushing
boarding123110233boarding
boasting113512503boasting
boating103721303bo_ating
bobbing113113193bo_bbing
bobbling12238643bobbling
boding104320063bo__ding
bodying1438973bo_dying
boffing16339983bo_ffing
bogeying1575703bogeying
bogging123615753bo_gging
boggling13257163boggling
boiling103819673bo_iling
boing84725553bo___ing
boinking15378423boinking
bolling103820883bo_lling
bolting104416763bo_lting
bombing143211393bo_mbing
bonding113318433bo_nding
bonging113316373bo_nging
boning94223293bo__ning
bonking144116373bo_nking
boobing123613913bo_obing
boodling121910243boodling
boogying1535373boogying
booing94521643bo__oing
booking143618383bo_oking
booming123716223bo_oming
boosting113311053boosting
booting103821363bo_oting
boozing194012163bo_ozing
bopping143512033bo_pping
borating113414503borating
boring94724873bo__ring
borking144716173bo_rking
bosoming1336643bosoming
bossing103714603bo_ssing
botch126717453botch___
botched153611903botch_ed
botcher143613223botch_er
botchers153511543botchers
botchery18366763botchery
botches143716023botch_es
botchiest1636153botchiest
botchy16537823botch__y
bothering152210203bothering
bothies12414783bot_hies
bottlings12215293bottlings
bottoming1444433bottoming
botulin947653botulin_
botulins1047063botulins
bouncing13318773bouncing
bounding123012133bounding
bousing103718043bo_using
boweling143410683boweling
bowering142911713bowering
bowing124723063bo__wing
bowling133916493bo_wling
bowsing134012503bo_wsing
boxing163915153bo__xing
boychick2443263boychick
boychik2143943boychi_k
boychiks2242933boychiks
bracing123817613brac_ing
branching17289263branching
breaching17269403breaching
breeching17236473breeching
bricking173911403bricking
brunching17316483brunching
brushing14359963brushing
bucking163617573b_ucking
buncoing13337813buncoing
bushing134018583b_ushing
butchering1844503butchering
butling103516813but_ling
butting103519283but_ting
caching156317503_caching
cinching163310223cinching
clothing14278783clot_hing
clutching17154823clutching
coacting133412703coacting
cochin131313203co_chin_
cochins141413103co_chins
cocking163619983co_cking
coshing134316433co_shing
coting94629253cot__ing
couchings17285763couchings
coughing15309213coughing
crouching1746383crouching
crutching17216073crutching
debouching1942723debouching
detaching1637263detaching
docking153615013do_cking
doting84821913dot__ing
dotting93314483dot_ting
eching126315563__eching
etchings14396293_etchings
filching1736113filching
fletching18256143fletching
flitching18265343flitching
forcing134013753forc_ing
frothing15208533frot_hing
grouching1644943grouching
grutching16224373grutching
hatchings18225673hatchings
hatchling1844953hatchling
hocking173417243ho_cking
hoicking1836053hoicking
honchoing1844873honchoing
hotting113116523hot_ting
hunching17309113hunching
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
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
sketching1935083sketching
slouching15195723slouching
smooching1734883smooching
smutching1734853smutching
snatching1536363snatching
snitching1535913snitching
socking143518603so_cking
soochong14104373soochong
soothing12269973soothing
souchong1484513souchong
soughing13259733soughing
southing122811823southing
splotching1842863splotching
stitching1547103stitching
stocking152912503stocking
switching1835703switching
synching17227713synching
teaching143612603teaching
thatching1835143thatching
thing96622983__t_hing
tithing113513893tit_hing
toothing12278863toothing
totaling9610303totaling
toting74123793tot__ing
totting82816843tot_ting
toughing13278553toughing
trothing122410843trot_hing
twitching1834243twitching
tything14316573tyt_hing
vetchling1843593vetchling
voicing13279083voic_ing
voting103916033vot__ing
welching17287363welching
wenching17328863wenching
winching17359903winching
witchings18325303witchings
withing143814493wit_hing
wooshing1536683wooshing
worthing15178053worthing
wotting112913843wot_ting
yocking173712373yo_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.1561145455.1
2DLD Change Limit1461622997.32619951.1
3Display Results2992990.1262373.0
 (SQL Overall)1786912997.60823487.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.