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 “botchily” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

66 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
botchily186437(None) 
bitchily1844531bitchily
blotchily1942681blotchily
botchedly2042592botchedly
botchery18366762botchery
botchier15287142botchier
botching16359702botching
botchy16537822botch__y
bunchily1844542bunchily
itchily1574492_itchily
patchily1885812patchily
pitchily1855012pitchily
tetchily1644122tetchily
touchily1645232touchily
batching163712093batching
bitchery18236563bitchery
bitchier15307733bitchier
bitching163610623bitching
bitchy16479203bitch__y
blotchier1643213blotchier
blotching1734963blotching
blotchy17293973blotch__y
bodily12310993bo__dily
bonnily1236873bo_nnily
boozily2135623bo_ozily
bossily1237563bo_ssily
botch126717453botch___
botched153611903botch_ed
botcher143613223botch_er
botchers153511543botchers
botches143716023botch_es
botchiest1636153botchiest
botfly1436093bot__fly
bothies12414783bot_hies
bothy136713963bot_h__y
bouncily1544383bouncily
boxily1877843bo__xily
boychick2443263boychick
boychik2143943boychi_k
boychiks2242933boychiks
bushily15268893b_ushily
butcherly19252653butcherly
butchery18326253butchery
catchfly2143333catchfly
cockily1838493co_ckily
dottily1147283dot_tily
frothily1745303frot_hily
godchild1642273godchild
grouchily1842843grouchily
hotching17309313hotching
mochila1446523mo_chila
mouthily1645903mouthily
notching14288583notching
orchil1158653_orchil_
orchils1277703_orchils
pithily1567033pit_hily
pockily1846233po_ckily
punchily1844863punchily
sketchily2142333sketchily
slouchily1742683slouchily
stockily1735443stockily
techily1537123_techily
toothily1445523toothily
twitchily2052193twitchily
worthily1745253worthily
zoophily2544913zoophily

Search took 7 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.423422437.4
2DLD Change Limit146162666.37322934.6
3Display Results66660.0164125.0
 (SQL Overall)178691666.81226231.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.