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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

146 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
cleanlinesses155388(None) 
cleanliness1343262cleanline_s_s
cleannesses13135822clean__nesses
uncleanlinesses1792152uncleanlinesses
blearinesses1446543blea_rinesses
canninesses1368853c__anninesses
chancinesses1945033c_hancinesses
clamminesses1873793cl_amminesses
classinesses1366113cl_assinesses
clearnesses13106153clea__rnesses
crankinesses1846143c_rankinesses
creakinesses1845983crea_kinesses
creaminesses1646123crea_minesses
deadlinesses1446223_deadlinesses
earlinesses11311033__earlinesses
lankinesses1539013_l_ankinesses
leafinesses1437873_lea_finesses
leakinesses1538473_lea_kinesses
leannesses10108343_lean__nesses
manlinesses13910193__manlinesses
mealinesses13310973_mea_linesses
queenlinesses2252273queenlinesses
slanginesses1346963sl_anginesses
sleazinesses2145373slea_zinesses
unmanlinesses1574303unmanlinesses
weaklinesses1944483_weaklinesses
womanlinesses1843133womanlinesses
bandinesses14109724__bandinesses
beadinesses1449554_bea_dinesses
beastlinesses1563424_beastlinesses
blandnesses1446624bl_an_dnesses
blanknesses1744934bl_an_knesses
bleaknesses1744034blea__knesses
breathinesses1853654breathinesses
caginesses13310934c__a_ginesses
cakinesses16310604c__a_kinesses
calmnesses1436834c__a_lmnesses
campinesses1737114c__ampinesses
candidnesses1685394c__andidnesses
canonesses1238414c__an_onesses
capablenesses1955434capablenesses
cattinesses13129704c__attinesses
charinesses1639564c_ha_rinesses
chattinesses1755154c_hattinesses
cheapnesses18104024chea__pnesses
cheekinesses2164204che_ekinesses
cheerinesses1765824che_erinesses
cheesinesses1765374che_esinesses
chewinesses1945144che__winesses
chillinesses1744984c_hillinesses
clannishnesses1952984cl_annishnesses
cleanliest1244354cleanli_e_s_t
cleanness1144974clean__ne_s_s
clevernesses1743624cle_vernesses
cloudinesses1545124cl_oudinesses
clubbinesses1843154cl_ubbinesses
clumsinesses1644754cl_umsinesses
comelinesses1666394c_omelinesses
corninesses13410584c_orn_inesses
costlinesses1446244c_ostlinesses
courtlinesses1544454courtlinesses
cowardlinesses2052514cowardlinesses
craftinesses1746374c_raftinesses
cragginesses1644504c_ragginesses
crazinesses2237924c_ra_zinesses
creepinesses1645254cre_epinesses
crumblinesses1952884crumblinesses
culpablenesses2053874culpablenesses
curablenesses17146954curablenesses
curlinesses1338724c__urlinesses
dailinesses1249494__dailinesses
dreaminesses1545704drea_minesses
drearinesses1347434drea_rinesses
easinesses10314414__ea_sinesses
elderlinesses1453254elderlinesses
fancinesses1638144__fancinesses
flabbinesses1943074fl_abbinesses
flakinesses1837074fl_a_kinesses
flashinesses18124864fl_ashinesses
fleshinesses18114364fle_shinesses
flintinesses1546324fl_intinesses
freakinesses1945584frea_kinesses
glarinesses1239514gl_a_rinesses
glassinesses1255244gl_assinesses
glazinesses2136404gl_a_zinesses
greasinesses1347034grea_sinesses
handinesses151410274__handinesses
headinesses1539844_hea_dinesses
heartinesses1547994_heartinesses
heavenlinesses2051794_heavenlinesses
heavinesses1747454_hea_vinesses
lacinesses12312104_l_a_cinesses
lanknesses1437504_l_an_knesses
larkinesses1538994_l_arkinesses
lazinesses19310144_l_a_zinesses
leadennesses1354574_leadennesses
learnednesses1443624_learnednesses
leerinesses11119474_le_erinesses
legginesses1345294_le_gginesses
levelnesses1445534_level_nesses
livelinesses15145624_livelinesses
loaminesses1358444_loa_minesses
lonelinesses12146344_lonelinesses
looninesses1197994_loon_inesses
lordlinesses1345154_lordlinesses
lovelinesses15125334_lovelinesses
lowlinesses1436684_l_owlinesses
manginesses1499594__manginesses
meannesses12128164_mean__nesses
meatinesses13311974_mea_tinesses
planenesses1349034pl_an_enesses
pliablenesses1756044pliablenesses
pliantnesses1444454plian_tnesses
preachinesses2043744preachinesses
queasinesses2144134quea_sinesses
randinesses121311204__randinesses
ranginesses121210114__ranginesses
readinesses12611264_rea_dinesses
realnesses10310844_rea_l_nesses
sandinesses12911394__sandinesses
scalinesses1339314_sca_linesses
scantinesses1437314_scantinesses
seaminesses13310754_sea_minesses
seemlinesses1445224_seemlinesses
slatinesses11311614sl_a_tinesses
sleepinesses1445674sle_epinesses
slinkinesses1645814sl_inkinesses
slovenlinesses1751764slovenlinesses
sneakinesses1645904snea_kinesses
steadinesses1346904stea_dinesses
steaminesses1446224stea_minesses
steelinesses1246724ste_elinesses
swankinesses1944784_swankinesses
sweatinesses1546904swea_tinesses
tanginesses1278884__tanginesses
tearinesses11311694_tea_rinesses
trendinesses1346324tre_ndinesses
uncanninesses1553134uncanninesses
uncleanliness1562294uncleanline_s_s
uncleannesses1553034unclean__nesses
uneasinesses1246624unea_sinesses
ungainlinesses1562834ungainlinesses
unhandinesses1753714unhandinesses
wearinesses14310214_wea_rinesses
yeastinesses1545564_yeastinesses
zaninesses19310374__zan_inesses

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.250714764.0
2DLD Change Limit950241466.55014507.5
3Display Results1461460.0931569.9
 (SQL Overall)1786911466.89325923.5
 
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.