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

144 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
botchery1836676(None) 
bitchery18236561bitchery
botcher143613221botcher_
botchers153511541botchers
butchery18326251butchery
batcher144414852batcher_
batchers153613272batchers
botched153611902botche_d
botchedly2042592botchedly
botches143716022botche_s
botchier15287142botchier_
botchily1864372botchily
botchy16537822botch__y
bother115218062bot_her_
bothers124317752bot_hers
butcher143411162butcher_
butcherly19252652butcherly
butchers153710182butchers
cutchery18265172cutchery
hatchery19326382hatchery
mothery153710512mot_hery
notcher123610932notcher_
notchers13279422notchers
ochery14319442_o_chery
witchery19236092witchery
archery15478063_archery
batched154114243batche_d
batches144019613batche_s
bather115322513bat_her_
bathers124720363bat_hers
battery124911823bat_tery
belcher143511493belcher_
belchers153510023belchers
bencher144113483bencher_
benchers153611013benchers
bewitchery2351663bewitchery
bitched153212923bitche_d
bitchen14349733bitche_n
bitches144117063bitche_s
bitchier15307733bitchier_
bitchily1844533bitchily
bitchy16479203bitch__y
blotched1635653blotche_d
blotches1537433blotche_s
blotchier1643213blotchier_
blotchily1942683blotchily
blotchy17293973blotch__y
blucher143310223blucher_
bluchers15359033bluchers
bobbery13438353bo_bbery
boche124216953bo_che__
boches134618523bo_che_s
bootery1238983bo_otery
botch126717453botch___
botcheries1746063botcheries
botchiest1636153botchiest
botching16359703botching
bothered142110393bot_hered
bothy136713963bot_h__y
bottler94211883bottler_
bottlers103810013bottlers
bottomry1542043bottomry
bouchee143313543bouche_e
bouchees15339533bouchees
bouldery14295013bouldery
bowery146012113bo__wery
broacher15329263broacher_
broachers16328153broachers
brother123311333brot_her_
brotherly1743793brot_herly
brothers133410833brot_hers
butchered1744583butchered
butcherer1643753butcherer
butches144315363butche_s
butlery12369423but_lery
buttery124311193but_tery
catcher143115823catcher_
catchers153114063catchers
coacher143714123coacher_
coachers154312303coachers
coucher144515853coucher_
couchers153513863couchers
crotchety19403813crotchety
ditcher134012003ditcher_
ditchers143610363ditchers
dithery14318943dit_hery
etcher113912943_etcher_
etchers123411293_etchers
fetcher153510393fetcher_
fetchers16328863fetchers
hatcher153314723hatcher_
hatchers163113173hatchers
hitcher153712003hitcher_
hitchers16379993hitchers
hotched163610923hotche_d
hotches153814363hotche_s
lathery133911123lat_hery
lechery15257643_lechery
lottery10389833lot_tery
matcher143214283matcher_
matchers153012433matchers
mockery18376913mo_ckery
moocher143610673moocher_
moochers15369123moochers
mother113718643mot_her_
motherly16346093mot_herly
mothers123717623mot_hers
notched134210303notche_d
notches123513653notche_s
nother93815963not_her_
ocher104516103_o_cher_
ochers113915303_o_chers
ochry13346933_o_ch_ry
other84219103_ot_her_
others93918003_ot_hers
patcher143515143patcher_
patchers153413303patchers
pitcher143813713pitcher_
pitchers153211483pitchers
poacher143912323poacher_
poachers152910763poachers
pother113818853pot_her_
potherb14358683pot_herb
pothers123818623pot_hers
potsherd1434813potsherd
pottery123011073pot_tery
rockery16439253ro_ckery
rotche114311983rotche__
rotches123515703rotche_s
smothery16296063smot_hery
sorcery1237033sorc_ery
stitchery17174073stitchery
tocher114014913to_cher_
tochers123413093to_chers
torchere1347683torchere
tother94117143tot_her_
tottery10388483tot_tery
toucher124814353toucher_
touchers133611213touchers
voucher154110263voucher_
vouchers16418623vouchers
watchcry2142363watchcry
watcher153113403watcher_
watchers163511793watchers

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.453394461.4
2DLD Change Limit1461621446.57622226.6
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.09225196.1
 
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.