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

76 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
scruffinesses215156(None) 
scruffiness1951692scruffine_s_s
stuffinesses1843292s_tuffinesses
craftinesses1746383_craftinesses
crumminesses1843653_crumminesses
crustinesses14137633_crustinesses
fluffinesses1742663_fluffinesses
gruffnesses1842923_gruff_nesses
huffinesses2034123__huffinesses
puffinesses1934513__puffinesses
scrappinesses1952293scrappinesses
scrawninesses1842423scrawninesses
screwinesses1744743scr_ewinesses
scurvinesses1743933sc_urvinesses
sniffinesses1843693s_niffinesses
spiffinesses2043013s_piffinesses
bluffnesses1942774_bluff_nesses
chubbinesses2142604_chubbinesses
chumminesses2142864_chumminesses
clubbinesses1843154_clubbinesses
clumsinesses1644774_clumsinesses
comfinesses1846914_c_omfinesses
cragginesses1644504_cragginesses
crankinesses1846144_crankinesses
crazinesses2237934_cr_azinesses
creakinesses1845994_creakinesses
creaminesses1646134_creaminesses
creepinesses1645254_creepinesses
crispinesses1645004_crispinesses
crudenesses1476654_cru_denesses
cruelnesses1346254_cru_elnesses
crumblinesses1952894_crumblinesses
crunchinesses2052864_crunchinesses
curlinesses1338734_c_urlinesses
cushinesses16127414_c_ushinesses
daffinesses1834844__daffinesses
draftinesses1645754_draftinesses
fruitinesses1546444_fruitinesses
grubbinesses1743284_grubbinesses
grumpinesses1743664_grumpinesses
iffinesses1635584___iffinesses
miffinesses1944364__miffinesses
ruddinesses1336034__ruddinesses
runninesses11137694__runninesses
runtinesses111210964__runtinesses
rustinesses11911554__rustinesses
ruttinesses11128994__ruttinesses
saucinesses1338984s_au_cinesses
scalinesses1339324sc__alinesses
scantinesses1437314sc_antinesses
scarinesses1339904sc__arinesses
scornfulnesses1953204scornfulnesses
scratchinesses2151764scratchinesses
scruffiest1842934scruffi_e_s_t
scrutinises1363304scru_tin_ises
shiftinesses18105244s_hiftinesses
slouchinesses1842804slouchinesses
slushinesses1445474s_lushinesses
smudginesses1643354s_mudginesses
smuttinesses14135084s_muttinesses
snubbinesses1643394s_nubbinesses
sorrinesses11310094sor__rinesses
springinesses16104064springinesses
sprucenesses1694614spru_cenesses
spunkinesses1844384s_punkinesses
stiffnesses1743594s_tiff_nesses
streakinesses1743634streakinesses
stringinesses14124534stringinesses
stuffiness1643694s_tuffine_s_s
sturdinesses1345794s_turdinesses
sulkinesses1557724s__ulkinesses
sunninesses11148384s__unninesses
surlinesses11310054s__urlinesses
thriftinesses1952314thriftinesses
trustinesses12116984_trustinesses
unrulinesses1245804unru_linesses

Search took 6 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 Filter178691950240.360496363.9
2DLD Change Limit95024764.90619368.9
3Display Results76760.0461652.2
 (SQL Overall)178691765.31233639.1
 
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.