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

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

71 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
succinctnesses17680(None) 
succinctness1561152succinctne_s_s
distinctnesses1752564distinctnesses
quaintnesses2143824qu_ain_tnesses
scantnesses1376534s__can_tnesses
strictnesses1445414s_tri_ctnesses
succinctest1451564succinct_e_s_t
supinenesses1446014su_pin_enesses
ancientnesses1553285_ancientnesses
chancinesses1945035__chancinesses
chicnesses1745215__chi_c_nesses
cunningnesses1673245cunnin_gnesses
currentnesses1552995curren_tnesses
faintnesses1447145__fain_tnesses
juicinesses2035895ju__i_cinesses
licitnesses1346415_lici__tnesses
lucidnesses1445245lu_ci__dnesses
luckinesses1746655lucki___nesses
lusciousnesses1556245lusciousnesses
publicnesses1842665publi_c_nesses
puckishnesses2443335pucki_shnesses
quicknesses2643755qu__i_cknesses
quietnesses2045605qu__i_etnesses
recentnesses1465375_recen_tnesses
saucinesses1338985sauci___nesses
scantinesses1437315s__cantinesses
scarcenesses1644495s__carcenesses
seasicknesses1873075seasi_cknesses
selectnesses1446115s__electnesses
shininesses1448295s__hin_inesses
sickishnesses2143665sicki_shnesses
sicknesses1636765s___i_cknesses
silentnesses1275445s_ilen_tnesses
skinninesses1643475s__kinninesses
slicknesses1745195s__li_cknesses
slightnesses1654625s__lightnesses
slinkinesses1645815s__linkinesses
spacinesses1538105spaci___nesses
spaciousnesses17147185spaciousnesses
specialnesses1753865speci_alnesses
speciousnesses17146905speciousnesses
spicinesses1547105s__pi_cinesses
spininesses1358455s__pin_inesses
springinesses16104065s_pringinesses
staunchnesses1851465s_taunchnesses
stinginesses1375965s__tinginesses
straightnesses1872585straightnesses
straitnesses1246215strai__tnesses
stringinesses14124535s_tringinesses
suasivenesses1546825suasi_venesses
subacidnesses1851695subaci__dnesses
sublimenesses1763385subli_menesses
subtilenesses1585065subti_lenesses
successes1345645su_c__c__esses
succinates1445635succinat____es
succincter1351925succinct____er
suchnesses1536675su____chnesses
suddennesses1442865sudden__nesses
sulkinesses1557725sulki___nesses
sullennesses1244345sullen__nesses
sunninesses11148385su___nninesses
surlinesses11310055surli___nesses
swiftnesses1744505s__wi_ftnesses
tacitnesses1336325_taci__tnesses
uncanninesses1553135_uncanninesses
unfitnesses1446135_unfi__tnesses
unkindnesses1744385_unkin_dnesses
uprightnesses19122785_uprightnesses
uptightnesses1982225_uptightnesses
vacantnesses1742975_vacan_tnesses
yuckinesses2044765yucki___nesses

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 Filter178691950240.360496363.9
2DLD Change Limit95024715.67016759.1
3Display Results71710.0501420.0
 (SQL Overall)178691716.08029390.0
 
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.