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

170 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
bitchery1823656(None) 
botchery18366761botchery
butchery18326251butchery
witchery19236091witchery
batcher144414852batcher_
batchers153613272batchers
bewitchery2351662bewitchery
bitched153212922bitche_d
bitchen14349732bitche_n
bitches144117062bitche_s
bitchier15307732bitchier_
bitchily1844532bitchily
bitchy16479202bitch__y
botcher143613222botcher_
botchers153511542botchers
butcher143411162butcher_
butcherly19252652butcherly
butchers153710182butchers
cutchery18265172cutchery
ditcher134012002ditcher_
ditchers143610362ditchers
dithery14318942dit_hery
hatchery19326382hatchery
hitcher153712002hitcher_
hitchers16379992hitchers
pitcher143813712pitcher_
pitchers153211482pitchers
stitchery17174072stitchery
aitches123014363aitche_s
archery15478063_archery
batched154114243batche_d
batches144019613batche_s
bather115322513bat_her_
bathers124720363bat_hers
battery124911823bat_tery
belcher143511493belcher_
belchers153510023belchers
bencher144113483bencher_
benchers153611013benchers
bewitcher1943003bewitcher_
bewitchers2042563bewitchers
bibbery13426543bi_bbery
bicker144819173bi_cker_
bickers154316553bi_ckers
bindery13459833bi_ndery
bioherm1434653bi_oherm
birched15349913birche_d
birchen14347883birche_n
birches143412323birche_s
bitch125017763bitch___
bitcheries1745903bitcheries
bitchiest1636083bitchiest
bitching163610623bitching
biter75030033bit__er_
biters83925243bit__ers
bitsier9379073bitsier_
bitter84622673bit_ter_
bitterly1335603bit_terly
bittern94810683bit_tern
bitters94920363bit_ters
bittier94211663bittier_
blithely16104033blit_hely
blither124812173blit_her_
blithers134711233blit_hers
blucher143310223blucher_
bluchers15359033bluchers
botched153611903botche_d
botchedly2042593botchedly
botches143716023botche_s
botchier15287143botchier_
botchily1864373botchily
botchy16537823botch__y
bother115218063bot_her_
bothers124317753bot_hers
britches15278683britche_s
butchered1744583butchered
butcherer1643753butcherer
butches144315363butche_s
butlery12369423but_lery
buttery124311193but_tery
catcher143115823catcher_
catchers153114063catchers
cither114616683cit_her_
cithern12489913cit_hern
cithers124315773cit_hers
ditched143711903ditche_d
ditches133215713ditche_s
dither104417683dit_her_
dithers114016153dit_hers
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
switcher16177683switcher_
switchers17146633switchers
tither94920283tit_her_
tithers104216733tit_hers
twitcher16135343twitcher_
twitchers17134533twitchers
watchcry2142363watchcry
watcher153113403watcher_
watchers163511793watchers
wincher153410653wincher_
winchers16319223winchers
witched163012193witche_d
witches152715793witche_s
witchier16307883witchier_
witchy17468593witch__y
wither124321353wit_her_
withers134417753wit_hers
zither183813083zit_her_
zithern19447023zit_hern
zithers193911973zit_hers

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.436409841.7
2DLD Change Limit1461621707.78318779.6
3Display Results1701700.0762236.8
 (SQL Overall)1786911708.29521542.0
 
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.