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

236 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
notching1428858(None) 
botching16359701botching
hotching17309311hotching
nothing113511901not_hing
batching163712092batching
bitching163610622bitching
blotching1734962blotching
catching163712772catching
coaching164011962coaching
couching163213262couching
ditching15349942ditching
douching15349842douching
etching134511842_etching
fetching17298412fetching
hatching173312212hatching
hitching173310522hitching
hutching17318642hutching
itching134011682_itching
latching143712022latching
letching143810262letching
matching163512392matching
mooching16259062mooching
mouching163110582mouching
niching133612432n_iching
nocking143615112no_cking
noncling11310762noncling
northing12199062northing
noshing114612772no_shing
notating92513342notating
nothings12266682not_hings
noticing1139452noticing
noting74120152not__ing
ouching134314902_ouching
patching163212752patching
pitching163411112pitching
poaching163510832poaching
pooching16328982pooching
pouching163210412pouching
retching143412172retching
roaching143210432roaching
scotching1735652scotching
snatching1536362snatching
snitching1535912snitching
torching142510082torching
touching143211342touching
vouching17308232vouching
watching173011172watching
witching173410632witching
aching126521973__aching
anything1534993anyt_hing
arching136216693_arching
attaching1545433attaching
avouching1843273avouching
baching156017753_baching
bathing134816243bat_hing
beaching164114143beaching
belching16349153belching
benching163411343benching
birching16328463birching
botchier15287143botchier
botchily1864373botchily
bottling11279143bottling
broaching17287663broaching
bunching163410703bunching
caching156317503_caching
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
enriching1546153enriching
etchings14396293_etchings
filching1736113filching
fletching18256143fletching
flitching18265343flitching
forcing134013753forc_ing
frothing15208533frot_hing
grouching1644943grouching
grutching16224373grutching
hatchings18225673hatchings
hatchling1844953hatchling
hocking173417243ho_cking
hoicking1836053hoicking
honchoing1844873honchoing
hotting113116523hot_ting
hunching17309113hunching
inarching1546343inarching
inching134414323_inching
itchings14386193_itchings
joshing18519413jo_shing
jotting152912773jot_ting
katchina1745333katchina
kithing153411553kit_hing
knocking14245943kno_cking
knotting13236573knot_ting
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
naething1236073naething
necking143913893n_ecking
neighing1355523neighing
netting84018763net_ting
nettling957213nettling
nicking143516323n_icking
nighing123410063n_ighing
nitchie1247233nitchi_e
nitchies1339073nitchies
nobbling13228273nobbling
nodding103811523no_dding
noddling11237263noddling
nogging103612723no_gging
noising83615173no_ising
nonacting1238783nonacting
nonbeing1137053nonbeing
noncaking1646683noncaking
noncoding1347673noncoding
noncoking1646813noncoking
nonteaching1753583nonteaching
nonusing939233nonusing
noodging11185693noodging
noodling10209443noodling
nooning83014853no_oning
noosing83315053no_osing
northings13185573northings
nosing73419843no__sing
notch105613323notch___
notched134210303notch_ed
notcher123610933notch_er
notchers13279423notchers
notches123513653notch_es
notifying1645623notifying
nudzhing2242033nudzhing
nutating92411953nutating
nutting83316233nut_ting
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
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
unhitching1942843unhitching
unlatching1643153unlatching
vetchling1843593vetchling
voicing13279083voic_ing
voting103916033vot__ing
welching17287363welching
wenching17328863wenching
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.440406115.9
2DLD Change Limit1461622367.90618487.5
3Display Results2362360.0932537.6
 (SQL Overall)1786912368.43921174.4
 
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.