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

275 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
witching17341063(None) 
bitching163610621bitching
ditching15349941ditching
hitching173310521hitching
itching134011681_itching
pitching163411111pitching
switching1835701switching
twitching1834241twitching
watching173011171watching
winching17359901winching
witchings18325301witchings
withing143814491wit_hing
batching163712092batching
bewitching2162772bewitching
birching16328462birching
botching16359702botching
catching163712772catching
cinching163310222cinching
etching134511842_etching
fetching17298412fetching
filching1736112filching
flitching18265342flitching
hatching173312212hatching
hotching17309312hotching
hutching17318642hutching
inching134414322_inching
itchings14386192_itchings
kithing153411552kit_hing
latching143712022latching
letching143810262letching
matching163512392matching
miching152911802mi_ching
niching133612432ni_ching
notching14288582notching
patching163212752patching
pinching163711052pinching
pithing134014052pit_hing
retching143412172retching
snitching1535912snitching
stitching1547102stitching
tithing113513892tit_hing
welching17287362welching
wenching17328862wenching
wicking173414772wi_cking
wincing133413902winc_ing
wishing144114892wi_shing
witchier16307882witchier
within123611382wit_hin_
withins133511692wit_hins
witing103522822wit__ing
witling113215812wit_ling
witting113417062wit_ting
writhing15278672writ_hing
aching126521973__aching
airthing12297953airthing
arching136216693_arching
attaching1545433attaching
baching156017753_baching
bathing134816243bat_hing
beaching164114143beaching
belching16349153belching
benching163411343benching
birthing14338433birthing
bitchen14349733bitchen_
bitchier15307733bitchier
bitchily1844533bitchily
bitewing1435293bitewing
biting95321823bit__ing
bitting103717293bit_ting
blotching1734963blotching
bunching163410703bunching
caching156317503_caching
circling1338423circling
citing94220183cit__ing
clinching17276123clinching
clutching17154823clutching
coaching164011963coaching
couching163213263couching
crutching17216073crutching
detaching1637263detaching
dicing105718763di_c_ing
dicking153617613di_cking
discing113914593disc_ing
discoing12511453discoing
dishing124017103di_shing
dittoing1036263dittoing
douching15349843douching
eching126315563__eching
etchings14396293_etchings
faithing1537153fait_hing
fishing143913863fi_shing
fitting113516563fit_ting
fletching18256143fletching
flinching18245833flinching
girthing13256083girthing
gitting93215703git_ting
grutching16224373grutching
hatchings18225673hatchings
hatchling1844953hatchling
hitting113017273hit_ting
hunching17309113hunching
icing86017753_i_c_ing
itchier12247673_itchier
itchily1574493_itchily
iteming1037753_iteming
katchina1745333katchina
kicking133314023ki_cking
kitchen16287683kitchen_
kitchens17195783kitchens
kiting114117093kit__ing
kitling123313573kit_ling
kitting123214443kit_ting
kittling1336063kittling
kvetching2242903kvetching
kything18285523kyt_hing
lathing114315693lat_hing
leaching143012833leaching
leching134613653_leching
leeching14318373leeching
lichting14268513li_chting
licking144118283li_cking
litchi1137893litchi__
litchis1238373litchi_s
lithoing1236743lithoing
lunching143110003lunching
lurching14277333lurching
lynching17336083lynching
marching164312193marching
milchig1543653milchi_g
mincing123314333minc_ing
miscuing1338733miscuing
mitering113015403mitering
mitring103514143mit_ring
mooching16259063mooching
mouching163110583mouching
mulching16287103mulching
munching16299973munching
nicking143516323ni_cking
nighing123410063ni_ghing
nitchie1247233nitchi_e
nitchies1339073nitchies
nothing113511903not_hing
ouching134314903_ouching
parching164313053parching
peaching163613643peaching
peching154513903_peching
perching163711633perching
picking163418333pi_cking
piecing12410453piec_ing
pishing134314373pi_shing
pitchier15368273pitchier
pitchily1855013pitchily
pitting103618873pit_ting
pitying132910243pit_ying
poaching163510833poaching
pooching16328983pooching
pouching163210413pouching
psyching1934483psyching
punching163310123punching
ranching141712043ranching
reaching143317203reaching
ricing94822763ri_c_ing
ricking143920233ri_cking
roaching143210433roaching
ruching133612933_ruching
scotching1735653scotching
scutching1735223scutching
siccing12319513si_ccing
sicking143720173si_cking
sighing123311663si_ghing
siting74126623sit__ing
sitting83519633sit_ting
sketching1935083sketching
smirching1744393smirching
smutching1734853smutching
snatching1536363snatching
sticking153513463sticking
swathing15248713swat_hing
swishing15277813swi_shing
synching17227713synching
teaching143612603teaching
thatching1835143thatching
thing96622983__t_hing
ticcing12308633ti_ccing
ticking143218753ti_cking
tincting1148883tincting
tithings12327693tit_hings
titling83715793tit_ling
torching142510083torching
touching143211343touching
trithing122811773trit_hing
twitchier1753233twitchier
twitchily2052193twitchily
twitting12307223twit_ting
tything14316573tyt_hing
unhitching1942843unhitching
vetchling1843593vetchling
vicing124014243vi_c_ing
vittling1236143vittling
vouching17308233vouching
waitering13310713waitering
waiting113618953wait__ing
washing145119283w_ashing
watchdog1842243watchdog
watering122316313watering
wattling12258783wattling
wauchting1843473wauchting
weighing1635283weighing
welshing15296523welshing
wetting114117383wet_ting
whacking21377483whacking
whishing18287183whishing
whitening1635103whitening
whitewing1943853whitewing
whiting143311303whit__ing
whittling1634383whittling
wickings18357183wi_ckings
widdling14228743widdling
widening13237833widening
widowing1635183widowing
wielding13286863wielding
wifing133513393wi__fing
wigging133413833wi_gging
wiggling14217293wiggling
wilding123814293wi_lding
wildling13248083wildling
wiling103024293wi__ling
willing113821613wi_lling
willying15306713willying
wilting113515913wi_lting
wimbling16186543wimbling
wimping153911013wi_mping
wimpling16207483wimpling
winding123517913wi_nding
windling132212263windling
wingding1436453wingding
winging123718713wi_nging
wining103625053wi__ning
winking153317963wi_nking
winkling16298293winkling
winning113516553wi_nning
wintering13412363wintering
wintling12249923wintling
wiping123916713wi__ping
wiring104521023wi__ring
wising103318223wi__sing
wisping133711943wi_sping
wissing113212943wi_ssing
wisting113519743wi_sting
witch134517563witch___
witched163012193witch_ed
witchery19236093witchery
witches152715793witch_es
witchiest1736313witchiest
witchlike2143103witchlike
witchy17468593witch__y
withering16108813withering
withier132910493wit_hier
withies133913543wit_hies
witlings12328443wit_lings
wittings12328733wit_tings
wiving133316603wi__ving
wizening21255463wizening
wooshing1536683wooshing
worthing15178053worthing
wotting112913843wot_ting
wracking18349963wracking
wrathing15248923wrathing
wrecking18328153wrecking
wrenching18276273wrenching
wricking18349493wricking
writing113713893writ__ing
wyting13277243wyt__ing
zincing192910283zinc_ing
zincking2435463zincking

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.440406115.9
2DLD Change Limit1461622756.75021653.6
3Display Results2752750.1062594.3
 (SQL Overall)1786912757.29624491.6
 
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.