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

208 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
witchier1630788(None) 
bitchier15307731bitchier
itchier12247671_itchier
pitchier15368271pitchier
twitchier1753231twitchier
withier132910491wit_hier
botchier15287142botchier
catchier15329862catchier
ditcher134012002ditch_er
glitchier1542792glitchier
hitcher153712002hitch_er
nitchie1247232nitchie_
nitchies1339072nitchies
patchier15319662patchier
pitcher143813712pitch_er
pithier123010292pit_hier
switcher16177682switch_er
tetchier1336452tetchier
twitcher16135342twitch_er
watcher153113402watch_er
wincher153410652winch_er
witched163012192witch_ed
witchery19236092witch_ery
witches152715792witch_es
witchiest1736312witchiest
witching173410632witching
wither124321352wit_h_er
withies133913542wit_hies
wittier103910822wit_tier
achier113914263__achier
aitches123014363aitch_es
batcher144414853batch_er
beachier1538803beachier
beechier1535633beechier
bewitcher1943003bewitch_er
bitched153212923bitch_ed
bitchen14349733bitch_en
bitchery18236563bitch_ery
bitches144117063bitch_es
bitchiest1636083bitchiest
bitchily1844533bitchily
bitching163610623bitching
bitsier9379073bit_sier
bittier94211663bit_tier
blotchier1643213blotchier
botcher143613223botch_er
bunchier1536153bunchier
butcher143411163butch_er
catcher143115823catch_er
chichier1836023chichier
chinchier1944633chinchier
cither114616683cit_h_er
dicier94416233di_c_ier
dickier143512453di_ckier
dictier103411863di_ctier
dishier113613403di_shier
ditched143711903ditch_ed
ditchers143610363ditch_ers
ditches133215713ditch_es
ditching15349943ditching
dither104417683dit_h_er
ditsier83010293dit_sier
ditzier17307963dit_zier
dowitcher1842593dowitch_er
either94517423eit_h_er
etcher113912943_etch_er
fetcher153510393fetch_er
filcher15377793filch_er
filthier1434073filthier
fishier13359853fi_shier
fitchee152710783fitch_ee
fitches153516193fitch_es
fitchet153113563fitch_et
fitchew18276803fitch_ew
hatcher153314723hatch_er
hitched163312253hitch_ed
hitchers16379993hitch_ers
hitches153616273hitch_es
hitchhiker2151263hitchhiker
hitching173310523hitching
hither124417253hit_h_er
icier74313753_i_c_ier
ickier12439923_i_ckier
incher114114033_inch_er
itched123812023_itch_ed
itches114916213_itch_es
itchiest1336523_itchiest
itchily1574493_itchily
itching134011683_itching
ither84617603_it_h_er
kickier12349053ki_ckier
kitchen16287683kitch_en
kvetchier2141863kvetchier
lathier10310833lat_hier
leachier1337253leachier
litchi1137893litchi__
litchis1238373litchi_s
lither94520953lit_h_er
luthier1038233lut_hier
matcher143214283match_er
mincier113512463minc_ier
mischief1846413mischief
mither114218563mit_h_er
mitier83620673mit__ier
mothier121910213mot_hier
mythier15125183myt_hier
nittier73512243nit_tier
notcher123610933notch_er
patcher143515143patch_er
peachier1548623peachier
pickier153912973pi_ckier
pincher143812713pinch_er
pitched153512923pitch_ed
pitchers153211483pitch_ers
pitches143617753pitch_es
pitchiest1646703pitchiest
pitchily1855013pitchily
pitching163411113pitching
pitchmen1744333pitchmen
pitier84019823pit__ier
poachier1556823poachier
pouchier1546803pouchier
punchier1536413punchier
reechier1336673reechier
richer114015043ri_ch_er
ritzier16297203rit_zier
sketchier1853413sketchier
smutchier1643503smutchier
snatchier1455353snatchier
snitcher13157373snitch_er
stickier14229763stickier
stitcher13168383stitch_er
swishier1434563swi_shier
switched17157133switch_ed
switchers17146633switch_ers
switches16159133switch_es
switching1835703switching
switchmen1962423switchmen
swither133710993swit_h_er
techier1269243_techier
thatchier1743983thatchier
tither94920283tit_h_er
torchier1337463torchier
touchier1347383touchier
twitched17155033twitch_ed
twitchers17134533twitch_ers
twitches16156373twitch_es
twitchiest1842963twitchiest
twitchily2052193twitchily
twitching1834243twitching
vichies15310623vi_chies
wackier16369733w_ackier
washier133611153w_ashier
watched163012823watch_ed
watchers163511793watch_ers
watches153017373watch_es
watching173011173watching
watchmen1844753watchmen
waterier11312083waterier
welcher15319393welch_er
wencher153811133wench_er
wether123315393wet_h_er
whackier2044673whackier
whither163510253whit_h_er
whitier133311063whit__ier
wiches144418753wi_ch_es
wicker154518673wi_c_ker
wieldier1234283wieldier
wifelier1434853wifelier
wiftier13297733wi_ftier
wiggier12418863wi_ggier
wigglier1354453wigglier
wilier93217073wi__lier
wimpier14248053wi_mpier
wincer115018193winc__er
winched163110593winch_ed
winchers16319223winch_ers
winches154714373winch_es
winching17359903winching
windier113412163wi_ndier
wingier113413283wi_ngier
winier94522453wi__nier
winterier1238333winterier
wintrier1136873wintrier
wirier94215553wi__rier
wiselier1137363wiselier
wisher123617063wi_sh_er
wispier12249403wi_spier
witch134517563witch___
witcheries1845463witcheries
witchings18325303witchings
witchlike2143103witchlike
witchweed2142773witchweed
witchy17468593witch__y
withe115220233wit_h_e_
withed134416233wit_h_ed
witherer14187953witherer
withers134417753wit_h_ers
withes124620843wit_h_es
withiest142411243wit_hiest
within123611383wit_hi_n
withing143814493wit_hing
withins133511693wit_hins
worthier1436713worthier
wrathier1435903wrathier
writher134010853writ_h_er
wuther124511613wut_h_er
zither183813083zit_h_er

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.1701051123.5
2DLD Change Limit1461622087.17320376.7
3Display Results2082080.0762736.8
 (SQL Overall)1786912087.41924085.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.