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

293 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
witchy1746859(None) 
bitchy16479201bitchy
fitchy17437621fitchy
itchy13449011_itchy
pitchy16479671pitchy
twitchy18393571twitchy
witch134517561witch_
withy144813761wit_hy
aitch105216162aitch_
bitch125017762bitch_
botchy16537822botchy
catchy16559582catchy
ditch115015092ditch_
fitch134816872fitch_
glitchy16283082glitchy
hitch134515472hitch_
itch95619172_itch_
kitschy1941982kitschy
litchi1137892litchi
patchy16509572patchy
pitch125018412pitch_
pithy135614462pit_hy
switch14458912switch_
tetchy1436002tetchy
twitch14406162twitch_
vichy1639042vi_chy
watch135617062watch_
wich125724752wi_ch_
wincey144110382wincey
winch135016662winch_
witched163012192witched
witchery19236092witchery
witches152715792witches
with105730482wit_h_
withe115220232wit_he
witney12356842witney
witty114717012wit_ty
achy126316093__achy
aitches123014363aitches
batch124620103batch_
beachy164011253beachy
beechy16397503beechy
bewitch1743323bewitch_
birch124914023birch_
bitched153212923bitched
bitchen14349733bitchen
bitchery18236563bitchery
bitches144117063bitches
bitchily1844533bitchily
bitsy104511303bit_sy
bitty106119173bit_ty
blotchy17293973blotchy
botch126717453botch_
bothy136713963bot_hy
bunchy16437463bunchy
butch125416543butch_
catch125120373catch_
chinchy20335523chinchy
cinch124516243cinch_
citify1437443citify
city95122633cit__y
clutchy17323893clutchy
conchy163710223conchy
cutch125116193cutch_
datcha1266563datcha
diarchy1644673diarchy
dicey114819333di_cey
dicky154816243di_cky
dicty115116293di_cty
dinghy14476963dinghy
dishy125712353di_shy
ditched143711903ditched
ditcher134012003ditcher
ditches133215713ditches
ditsy95612563dit_sy
ditty95019293dit_ty
ditzy186513283dit_zy
duchy144310873_duchy
dutch114713823dutch_
etch95419143_etch_
fetch134913473fetch_
fiche134616743fi_che
fichu134810663fi_chu
filch134813323filch_
filthy15356423filthy
finch135416973finch_
fishy146011663fi_shy
fitchee152710783fitchee
fitches153516193fitches
fitchet153113563fitchet
fitchew18276803fitchew
fitly115114973fit_ly
flitch14928173flitch_
glitch12286353glitch_
gotcha1234633gotcha
hatch135719593hatch_
hitched163312253hitched
hitcher153712003hitcher
hitches153616273hitches
hotch136214733hotch_
hutch135414093hutch_
ich86227753_i_ch_
ichs96214713_i_chs
icky136315753_i_cky
icy86322133_i_c_y
inch95420823_inch_
itched123812023_itched
itches114916213_itches
itchily1574493_itchily
jitney16304623jitney
ketch144912023ketch_
kicky135012343ki_cky
kimchi1743803kimchi
kitchen16287683kitchen
kith115826373kit_h_
kithe125917463kit_he
kiths125814983kit_hs
kitsch1533353kitsch_
kitty124614573kit_ty
kvetchy2241803kvetchy
latch104620463latch_
lathy115215063lat_hy
leachy14419733leachy
letch105215803letch_
lich96230853li_ch_
lichi104412953li_chi
licht104723493li_cht
litany939053litany
litchis1238373litchis
lithe84922013lit_he
litho86513783lit_ho
match125621103match_
miche126219243mi_che
milch124413373milch_
mincy125817413minc_y
mity95528223mit__y
mothy136214553mot_hy
mutch125016173mutch_
mythy16568673myt_hy
natch105018223natch_
niche105016793ni_che
nitchie1247233nitchie
nitery94412173nitery
nitty85418313nit_ty
notch105613323notch_
outcry1137993outcry
patch125221223patch_
peachy164510843peachy
picky165416943pi_cky
pinch125619303pinch_
pitched153512923pitched
pitcher143813713pitcher
pitches143617753pitches
pitchily1855013pitchily
pith95432703pit_h_
piths105817543pit_hs
pity96031943pit__y
poachy16388963poachy
pouchy16538663pouchy
punchy16398523punchy
quitch2036413quitch_
ratch104221363ratch_
reechy14367823reechy
retch104818303retch_
rich97025553ri_ch_
richly1438013ri_chly
ritzy175611163rit_zy
rotch105815933rotch_
rotche114311983rotche
sitcom1036903sitcom
sith75435163sit_h_
sketchy1943053sketchy
smithy14508273smit_hy
smutchy17193153smutchy
snatchy15355293snatchy
snitch11357943snitch_
stich104117923stich_
stichs114511653stichs
sticky154711343sticky
stitch11419103stitch_
stithy12398213stithy
swatch14549283swatch_
swishy15365843swi_shy
switched17157133switched
switcher16177683switcher
switches16159133switches
swith115917403swit_h_
swithe124010683swit_he
swithly1634443swithly
techy135612013_techy
thatchy1833303thatchy
thy97022913__t_hy
tithe85319703tit_he
titty85316653tit_ty
torchy14549533torchy
touchy145010503touchy
twitched17155033twitched
twitcher16135343twitcher
twitches16156373twitches
twitchily2052193twitchily
vetch134411843vetch_
wacky174714933w_acky
washy145911843w_ashy
watchcry2142363watchcry
watched163012823watched
watcher153113403watcher
watches153017373watches
watcheye19104273watcheye
watery123914493watery
waucht14399413waucht
wecht13415443w_echt
welch134411493welch_
wench136214783wench_
wetly114511713wet_ly
whacky21556493whacky
which163910083which_
whitely16346473whitely
whitey154911883whit_ey
whity145513473whit__y
why126920013w___hy
wicca1247253wi_cca
wiccan1335033wiccan
wiccas1336543wiccas
wiches144418753wi_ches
wick135726313wi_c_k
wicks144619363wi_cks
wicopy1634033wicopy
widdy136112193wi_ddy
widely133311033widely
width12310973width_
widths1335123widths
wieldy13476183wieldy
wifely15429423wifely
wifey144913673wi_fey
wifty144212093wi_fty
wiggly14559683wiggly
wiggy134510733wi_ggy
wight123725573wi_ght
wilco1039443wilc_o
wildly13328123wildly
wilily123310763wilily
willy115321913wi_lly
wily106428823wi__ly
wimpy155911923wi_mpy
wince105220883winc_e
winced124415343winced
wincer115018193wincer
winces114819113winces
winceys15395523winceys
winched163110593winched
wincher153410653wincher
winches154714373winches
windy126118113wi_ndy
winery125014283winery
winey115325433wi_ney
wingy126521033wi_ngy
wintery13399753wintery
wintry12498923wintry
winy107034333wi__ny
wirily123310783wirily
wiry106422843wi__ry
wisely122711713wisely
wish107228743wi_sh_
wisha114910853wi_sha
wispy137210973wi_spy
wit66563783wit___
witan83816503wit_an
witans93412933witans
witchier16307883witchier
witching173410633witching
wite75443283wit__e
wited94727143wit_ed
wites85536963wit_es
withal1238933withal
withed134416233withed
wither124321353wither
withes124620843withes
within123611383within
witing103522823witing
witneys13274723witneys
wits76044883wit__s
witted104216813witted
wittily1336173wittily
wittol935923wittol
worthy15598803worthy
wrathy15377853wrathy
wretch14326533wretch_
writhe125310703writ_he
wych154011883w_ych_
yechy16519083_yechy
zilch19438123zilch_
zincky24404963zincky
zincy195413513zinc_y

Search took 6 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 Filter1786911127160.516346300.4
2DLD Change Limit1127162934.76623650.0
3Display Results2932930.0933150.5
 (SQL Overall)1786912935.37533244.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.