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

47 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
towsacks174417(None) 
towsack1644721towsack_
cossacks1645222cossacks
hopsacks1944732hopsacks
thwacks1953612thw_acks
tombacks18216452tombacks
blowbacks2243673blowbacks
coalsacks1743513coalsacks
corsacs1139013corsac_s
cossack1545823cossack_
cowlicks1944663cowlicks
fossicks17134163fossicks
hogbacks2044853hogbacks
hopsack1845273hopsack_
mossbacks1943713mossbacks
oomiacks1643533oomiacks
plowbacks2243123plowbacks
pollacks1656373pollacks
ransacks1445773ransacks
rowlocks1744353rowlocks
sacks114228873___sacks
snowpacks2042583snowpacks
tacks115430133t___acks
thacks154311923t__hacks
throwbacks24734563throwbacks
thwack1834213thw_ack_
tiebacks1646333tiebacks
tomback17227743tomback_
tombacs13248433tombac_s
tombaks15246853tomba_ks
topkicks1542633topkicks
topsails1075093topsails
torsades937203torsades
torsks10549123tors__ks
touracos1045293touracos
towages1139233tow_ages
towards1138783tow_ards
towpaths1643113towpaths
tracks124818843t__racks
tripacks1664893tripacks
tussocks1443333tussocks
tussucks1442433tussucks
tweaks1335963t_wea_ks
wacks146626283__w_acks
whacks184610483__whacks
woolsacks1842953woolsacks
wracks154711113__wracks

Search took 10 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.1561145455.1
2DLD Change Limit146162478.84316528.6
3Display Results47470.0162937.5
 (SQL Overall)178691479.01519821.5
 
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.