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

42 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
squinniest194342(None) 
squinnies1844481squinnies_
squintiest1944991squintiest
skinniest1335522s_kinniest
squiffiest2542662squiffiest
squinnied1942672squinnie_d
squinnier1843032squinnie_r
squintest1845702squi_ntest
squirmiest2142792squirmiest
squishiest2244322squishiest
sunniest82712912s_u_nniest
finniest113011403__finniest
funniest113010733_fu_nniest
ginniest92610513__ginniest
punniest102511583_pu_nniest
quinines172410203_quinines_
quinsies1737623_quinsies_
quippiest2243993_quippiest
quirkiest2234373_quirkiest
runniest82911203_ru_nniest
shiniest113212503s_hi_niest
shinnies113010913s_hinnies_
skunkiest12135093sku_nkiest
slinkiest13188083s_linkiest
spiniest102813233s_pi_niest
spinnies103210543s_pinnies_
springiest13156683springiest
spunkiest15166573spu_nkiest
squabbiest2342863squabbiest
squalliest1944143squalliest
squashiest2244133squashiest
squattiest1944243squattiest
squeakiest2342793squeakiest
squiggliest2251693squiggliest
squinches2344253squinches_
squintier1844473squintie_r
stingiest10209773s_tingiest
stinkiest13198463s_tinkiest
stringiest11197593stringiest
swingiest13207573s_wingiest
tinniest82911463__tinniest
whinniest15245133_whinniest

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 Filter1786911406030.406440125.6
2DLD Change Limit140603426.62321229.5
3Display Results42420.0162625.0
 (SQL Overall)178691427.04525364.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.