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

69 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
uncleanlinesses179215(None) 
cleanlinesses1553882__cleanlinesses
uncleanliness1562292uncleanline_s_s
uncleannesses1553032unclean__nesses
uncanninesses1553133unc__anninesses
unmanlinesses1574303un__manlinesses
cleanliness1343264__cleanline_s_s
cleannesses13135824__clean__nesses
uncleanliest1452224uncleanli_e_s_t
uncleanness1352844unclean__ne_s_s
uneasinesses1246624un__ea_sinesses
ungainlinesses1562834un_gainlinesses
unhandinesses1753714un__handinesses
unlikelinesses1852634un_likelinesses
unlovelinesses1752454un_lovelinesses
unreadinesses1484574un_rea_dinesses
unseemlinesses1652284un_seemlinesses
unsteadinesses1553064unstea_dinesses
ancientnesses1553285ancie_n_tnesses
blearinesses1446545__blea_rinesses
canninesses1368855__c__anninesses
chancinesses1945035__c_hancinesses
clamminesses1873795__cl_amminesses
classinesses1366115__cl_assinesses
clearnesses13106155__clea__rnesses
crankinesses1846145__c_rankinesses
creakinesses1845985__crea_kinesses
creaminesses1646125__crea_minesses
deadlinesses1446225___deadlinesses
earlinesses11311035____earlinesses
heavenlinesses2051795heave_nlinesses
incapablenesses2184245incapablenesses
lankinesses1539015___l_ankinesses
leafinesses1437875___lea_finesses
leakinesses1538475___lea_kinesses
leannesses10108345___lean__nesses
maidenlinesses1751975maide_nlinesses
manlinesses13910195____manlinesses
mealinesses13310975___mea_linesses
queenlinesses2252275__queenlinesses
scalinesses1339315_sc__a_linesses
scantinesses1437315_sc__antinesses
slanginesses1346965__sl_anginesses
sleazinesses2145375__slea_zinesses
slovenlinesses1751765slove_nlinesses
sneakinesses1645905sn__ea_kinesses
uncanniness1353405unc__annine_s_s
uncertainnesses1781355unc_ertainnesses
unchastenesses1962915unc_hastenesses
uncleanlier1351715uncleanli____er
unearthlinesses1861855unearthlinesses
unevennesses1544075uneve_n__nesses
ungodlinesses1563305un__godlinesses
unhappinesses2052485un__happinesses
unhealthinesses2161625un_healthinesses
unholinesses1544905un___holinesses
unkindlinesses1952565un_kindlinesses
unluckinesses1952475un_l_uckinesses
unmanliness1344025un__manline_s_s
unrulinesses1245805un___rulinesses
unsightlinesses1962215unsightlinesses
unstablenesses1656005un_stablenesses
untimelinesses16103185un_timelinesses
unusualnesses1353055unusua_l_nesses
unwarinesses1546155un__wa_rinesses
unwieldinesses1851935unwie_ldinesses
unworldlinesses1991815unworldlinesses
weaklinesses1944485___weaklinesses
womanlinesses1843135__womanlinesses

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 Filter178691658740.0931921408.6
2DLD Change Limit65874696.7969693.1
3Display Results69690.093741.9
 (SQL Overall)178691696.98225593.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.