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 “stupidest” 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
stupidest124414(None) 
soupiest102212912soupi_est
staidest939802st_aidest
stolidest1046112stolidest
stumpiest1335852stumpi_est
stupider1133912stupide_r
stupidness1343032stupidness
stupids1035272stupid_s_
sturdiest10207392sturdiest
rapidest1138543_rapidest
roupiest102610293roupi_est
sappiest122612573sappi_est
sauciest10310973sauci_est
seepiest102412623seepi_est
sirupiest1154753sirupi_est
snidest8310913s__nidest
soapiest102412843soapi_est
solidest9310383s_olidest
soppiest122511933soppi_est
soundest9510973sou_ndest
spumiest1238203spumi_est
squalidest2043393squalidest
stagiest91613403stagi_est
stapedes11197753stapedes_
steadiest1038513steadiest
stipites1039653stipites_
stoniest8413543stoni_est
straitest949173straitest
strident9310173st_rident
strides84520393st_rides_
stripiest1138013stripiest
stubbiest1345483stubbiest
studdies10207073studdies_
student848343stu__dent
studies82413863studi_es_
studliest1036573studliest
stuffiest15235953stuffiest
stupes84116953stup__es_
stupid937593stupid___
stupidity1543093stupidity
stupidly1442633stupid_ly
sturdies92110273sturdies_
supines94216383s_upines_
supplest1248943s_upplest
syrupiest1453223syrupi_est
timidest1136933_timidest
typiest1238203_typi_est

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 Filter1786911486410.423422437.4
2DLD Change Limit148641476.45323034.4
3Display Results47470.0331424.2
 (SQL Overall)178691476.90925863.5
 
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.