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

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

46 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
downstrokes195183(None) 
downstroke1852141downstroke_
downstages1543293downst_ages
downstates1444343downst_ates
instrokes1345353__instrokes
outstrokes1464583_outstrokes
sunstrokes1443123_sunstrokes
backstrokes1873064backstrokes
brownstones16142844brownst_ones
construes11410134co_nstr_ues
downcomes1743984down__comes
downforces1952274downfor_ces
downgrades1652724down_grades
downscales1653284downs_cales
downsides1444814downs__ides
downsizes2243874downs__izes
downslides1542754downs_lides
downslope1553024downs_lope_
downspouts16141914downs_pouts
downstage1443374downst_age_
downstairs1452514downst_airs
downstate1344614downst_ate_
downstater1453114downst_ater
downstaters1552074downstaters
downstream1652034downstr_eam
downthrows2051704downthro_ws
downticks1942964down_tick_s
downtimes1544514down_t_imes
downtowns1642934down_t_owns
downtrends1551474down_trends
downtrod1343354down_tro__d
downtrodden1761034down_trodden
downzones22123844down__zones
heatstrokes1852254heatstrokes
hornstones13106074hornst_ones
instroke1245584__instroke_
keystrokes1652124_keystrokes
monstrous1187354mo_nstro_us
moonstones1246054moonst_ones
nonstories1049764no_nstories
oestrones949774_o_estrones
outstroke1365214_outstroke_
sidestrokes1662364sidestrokes
strokes114316324____strokes
sunstroke1343204_sunstroke_
upstrokes1543154__upstrokes

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 Filter1786911488190.1561145455.1
2DLD Change Limit148819469.42315793.2
3Display Results46460.0301533.3
 (SQL Overall)178691469.60918596.2
 
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.