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

50 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
squattest184461(None) 
squattiest1944231squattiest
squarest17338222squa_rest
squatness1844942squatness
squatted1835342squatte_d
squatter1735912squatte_r
squatters1834942squatters
squintest1845702squintest
attest62618613___attest
coattest1038863_coattest
equates162012323equa_tes_
fattest102913063__fattest
flattest1138713_flattest
phattest1336913_phattest
quaintest1845343_quaintest
quakiest2138583_quakiest
quartes163314933_quartes_
quartet162814893_quarte_t
quartets17277573_quartets
quatres163411933_quatres_
quietest1757173_quietest
saltest71916513s__altest
scantest101710183s_cantest
scattiest11268363s_cattiest
sedatest9249393seda_test
slatiest82616263s_latiest
sluttiest937333sluttiest
smartest10310183s_martest
smuttiest1135973smuttiest
squabbiest2342853squabbiest
squalidest2043393squalidest
squalliest1944133squalliest
squamates2045593squamates_
squares163714463squa_res_
squashes20207803squashes_
squashiest2244123squashiest
squats153712963squa_t_s_
squattered2043253squattered
squattier1843713squattier
squattily2142653squattily
squatting1934513squatting
squatty1964823squatt__y
squeakiest2342783squeakiest
squintiest1944993squintiest
straitest949173straitest
suavest10310623s_ua_vest
subtest9513963s_u_btest
subtlest10511363s_ubtlest
sweatiest1238413sweatiest
wattest102412153__wattest

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.436409841.7
2DLD Change Limit148641507.12620859.0
3Display Results50500.0301666.7
 (SQL Overall)178691507.59223536.7
 
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.