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

179 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
witchery1923609(None) 
bitchery18236561bitchery
bewitchery2351662bewitchery
botchery18366762botchery
butchery18326252butchery
cutchery18265172cutchery
ditcher134012002ditcher_
ditchers143610362ditchers
dithery14318942dit_hery
hatchery19326382hatchery
hitcher153712002hitcher_
hitchers16379992hitchers
pitcher143813712pitcher_
pitchers153211482pitchers
stitchery17174072stitchery
switcher16177682switcher_
switchers17146632switchers
twitcher16135342twitcher_
twitchers17134532twitchers
watchcry2142362watchcry
watcher153113402watcher_
watchers163511792watchers
wincher153410652wincher_
winchers16319222winchers
witched163012192witche_d
witches152715792witche_s
witchier16307882witchier_
witchy17468592witch__y
wither124321352wit_her_
withers134417752wit_hers
aitches123014363aitche_s
archery15478063_archery
batcher144414853batcher_
batchers153613273batchers
bewitcher1943003bewitcher_
bewitchers2042563bewitchers
bitched153212923bitche_d
bitchen14349733bitche_n
bitches144117063bitche_s
bitchier15307733bitchier_
bitchily1844533bitchily
bitchy16479203bitch__y
botcher143613223botcher_
botchers153511543botchers
butcher143411163butcher_
butcherly19252653butcherly
butchers153710183butchers
catcher143115823catcher_
catchers153114063catchers
cither114616683cit_her_
cithern12489913cit_hern
cithers124315773cit_hers
ditched143711903ditche_d
ditches133215713ditche_s
dither104417683dit_her_
dithers114016153dit_hers
dowitcher1842593dowitcher_
dowitchers1942133dowitchers
either94517423eit_her_
etcher113912943_etcher_
etchers123411293_etchers
fetcher153510393fetcher_
fetchers16328863fetchers
filcher15377793filcher_
filchers16286863filchers
fishery16397733fi_shery
fitchee152710783fitche_e
fitches153516193fitche_s
fitchet153113563fitche_t
fitchets16307413fitchets
fitchew18276803fitche_w
fitchews19274773fitchews
fitchy17437623fitch__y
hatcher153314723hatcher_
hatchers163113173hatchers
hitched163312253hitche_d
hitches153616273hitche_s
hither124417253hit_her_
incher114114033_incher_
inchers123912523_inchers
itched123812023_itche_d
itches114916213_itche_s
itchier12247673_itchier_
itchily1574493_itchily
itchy13449013_itch__y
ither84617603_it_her_
jittery17346443jit_tery
kitchen16287683kitche_n
kitchens17195783kitchens
lathery133911123lat_hery
lechery15257643_lechery
lithely1356643lit_hely
lither94520953lit_her_
littery103710493lit_tery
matcher143214283matcher_
matchers153012433matchers
mither114218563mit_her_
mithers123516733mit_hers
mothery153710513mot_hery
nitery94412173nit__ery
notcher123610933notcher_
notchers13279423notchers
ochery14319443__ochery
patcher143515143patcher_
patchers153413303patchers
pincher143812713pincher_
pinchers153510613pinchers
pitched153512923pitche_d
pitches143617753pitche_s
pitchier15368273pitchier_
pitchily1855013pitchily
pitchy16479673pitch__y
richer114015043ri_cher_
slithery14356703slit_hery
smithery16325703smit_hery
snitcher13157373snitcher_
snitchers14166043snitchers
stitcher13168393stitcher_
stitchers14147013stitchers
switched17157133switche_d
switcheroo1852063switcheroo
switches16159133switche_s
swither133710993swit_her_
swithers144310533swit_hers
tither94920283tit_her_
tithers104216733tit_hers
twitched17155033twitche_d
twitches16156373twitche_s
twitchier1753233twitchier_
twitchily2052193twitchily
twitchy18393573twitch__y
twittery14303893twit_tery
watched163012823watche_d
watches153017373watche_s
watcheye19104273watcheye
watery123914493wat__ery
welcher15319393welcher_
welchers16338053welchers
wencher153811133wencher_
wenchers16319213wenchers
wether123315393wet_her_
wethers135214693wet_hers
whither163510253whit_her_
wiches144418753wi_che_s
wicker154518673wi_cker_
wickers164114703wi_ckers
wiggery15295873wi_ggery
wincer115018193winc_er_
wincers123415363winc_ers
wincey144110383winc_e_y
winched163110593winche_d
winches154714373winche_s
winery125014283wi__nery
wintery13399753wi_ntery
wisher123617063wi_sher_
wishers133215213wi_shers
witch134517563witch___
witcheries1845463witcheries
witchiest1736313witchiest
witching173410633witching
witchweed2142773witchweed
withe115220233wit_he__
withed134416233wit_he_d
withered15169433wit_hered
witherer14187953wit_herer
witherod15156153wit_herod
withes124620843wit_he_s
withheld1842353withheld
withier132910493withier_
withy144813763wit_h__y
witney12356843wit_ne_y
wittier103910823wittier_
writher134010853writ_her_
writhers14398983writ_hers
wuther124511613wut_her_
wuthers133711523wut_hers
zither183813083zit_her_
zithern19447023zit_hern
zithers193911973zit_hers

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 Limit1461621797.12320519.7
3Display Results1791790.0802237.5
 (SQL Overall)1786911797.64323379.7
 
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.