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

60 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
stitchery1717407(None) 
stitcher13168391stitcher_
stitchers14147011stitchers
bitchery18236562_bitchery
slithery14356702slit_hery
smithery16325702smit_hery
snitcher13157372snitcher_
snitchers14166042snitchers
stitched14148202stitche_d
stitches131410592stitche_s
switcher16177682switcher_
switchers17146632switchers
witchery19236092_witchery
bewitchery2351663bewitchery
botchery18366763_botchery
butchery18326253_butchery
cutchery18265173_cutchery
ditcher134012003_ditcher_
ditchers143610363_ditchers
dithery14318943_dit_hery
hatchery19326383_hatchery
hitcher153712003_hitcher_
hitchers16379993_hitchers
pitcher143813713_pitcher_
pitchers153211483_pitchers
scutcher15176963scutcher_
scutchers16175643scutchers
sketcher1735433sketcher_
sketchers1834513sketchers
skittery15315103skit_tery
slither104112983slit_her_
slithers114212953slit_hers
smithers13369793smit_hers
smothery16296063smot_hery
snatcher13167763snatcher_
snatchers14146313snatchers
snickery17295543sni_ckery
snitched14166863snitche_d
snitches13148983snitche_s
spicery14499013spi_c_ery
stancher13198813stancher_
stanchers14206813stanchers
sticker133515883sti_cker_
stickers142913033sti_ckers
stitch11419103stitch___
stitcheries1653073stitcheries
stitching1547103stitching
stitchwort1852543stitchwort
stithy12398213stit_h__y
stretcher1446293stretcher_
stretchers1545173stretchers
switched17157133switche_d
switcheroo1852063switcheroo
switches16159133switche_s
swither133710993swit_her_
swithers144310533swit_hers
tither94920283_tit_her_
tithers104216733_tit_hers
twitcher16135343twitcher_
twitchers17134533twitchers

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 Filter1786911486410.420425454.8
2DLD Change Limit148641606.89321564.1
3Display Results60600.0134615.4
 (SQL Overall)178691607.32624391.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.