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

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

149 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
palatialnesses165333(None) 
palatialness1453202palatialne_s_s
fanaticalnesses2082273fanaticalnesses
palatablenesses1973913palatablenesses
amativenesses1856764_amativenesses
colonialnesses1653044colonialnesses
factualnesses1853684fa_ctualnesses
fatalnesses1456264__fat_alnesses
habitualnesses1962194habitualnesses
initialnesses1395594_initialnesses
maltinesses13310224mal_ti__nesses
materialnesses1653904materialnesses
pallidnesses1543924pal_li_dnesses
paltrinesses1445514pal_t_rinesses
pastinesses13911704pa_sti__nesses
pastoralnesses1653124pastoralnesses
placidnesses1743944p_laci_dnesses
plainnesses1356204p_la_i_nnesses
playfulnesses2153644p_layfulnesses
poeticalnesses1853084p_oeticalnesses
practicalnesses2162914practicalnesses
saltinesses11311444sal_ti__nesses
slatinesses11311614_slati__nesses
talkativenesses2273394talkativenesses
volatilenesses1754454volatilenesses
activenesses1758185_a_ctivenesses
adaptivenesses2054245_adaptivenesses
algidnesses1345165_al_gi_dnesses
aliennesses1145865_al__iennesses
alikenesses1547195_al__ikenesses
alivenesses1448855_al__ivenesses
artfulnesses1546635_a_rtfulnesses
artinesses10815195_a_rti__nesses
balefulnesses1844855bal_efulnesses
balkinesses1767495bal_ki__nesses
balminesses1537245bal_mi__nesses
battinesses13169445ba_tti__nesses
belatednesses1644315belat_ednesses
casualnesses1443775__casualnesses
cattinesses13129705ca_tti__nesses
coltishnesses1845215col_tishnesses
cordialnesses1654555_cordialnesses
creativenesses1967015creativenesses
criticalnesses1853125_criticalnesses
cultishnesses1844565cul_tishnesses
daintinesses1346245dainti__nesses
dilatorinesses1552055dilatorinesses
doltishnesses1744605dol_tishnesses
elatednesses1346095_elat_ednesses
essentialnesses1462615essentialnesses
faintishnesses2053305faintishnesses
familiarnesses1971775familiarnesses
fanaticalness1862695fanaticalne_s_s
fattinesses14118975fa_tti__nesses
faultinesses1545185faulti__nesses
flakinesses1837075_flaki__nesses
flatnesses1337765_flat___nesses
frailnesses1447575_fra_i_lnesses
glarinesses1239515_glari__nesses
glaringnesses1553395_glaringnesses
glazinesses2136405_glazi__nesses
gradualnesses1552865_gradualnesses
hastinesses141210685ha_sti__nesses
identicalnesses1882405identicalnesses
illogicalnesses1871655illogicalnesses
insatiatenesses1593475insatiatenesses
jauntinesses1944685jaunti__nesses
lacinesses12312105__laci__nesses
lastingnesses1444135la_stingnesses
latenesses10413355__lat__enesses
lavishnesses1844775__lavishnesses
lawfulnesses1844145__lawfulnesses
lazinesses19310145__lazi__nesses
liltingnesses1453575lil_tingnesses
literalnesses1355235__literalnesses
localnesses1345845__l_ocalnesses
logicalnesses1653175__logicalnesses
lyricalnesses1853085__lyricalnesses
malapertnesses1881385malapertnesses
matinesses12314525__mati__nesses
meatinesses13311975_meati__nesses
nastinesses111110725na_sti__nesses
nativenesses1548535__nativenesses
nattinesses11119315na_tti__nesses
naturalnesses1354245na_turalnesses
negativenesses1855845negativenesses
neutralnesses1354335_neutralnesses
oblatenesses1475765oblat__enesses
operativenesses2055755operativenesses
painfulnesses18115135pa_infulnesses
painterlinesses1792015painterlinesses
palatableness1754635palatablenes_s
palatalizes2244835palat_al__izes
palatinates1344995palati__n_ates
palatines11313015palati__n___es
palenesses12312655pal____enesses
palliasses1283585pal_lia___sses
paperinesses1646045paperi__nesses
passivenesses1746635pa_ssivenesses
pastnesses12910505pa_st___nesses
patchinesses1944365p__atchinesses
patnesses111611795p__at___nesses
patronesses1346475p__at_ronesses
pawkinesses2036155pa_wki__nesses
petitenesses14169315p__etitenesses
pettinesses1338625p_etti__nesses
pettishnesses1844385p_ettishnesses
physicalnesses2461935physicalnesses
pictorialnesses1962135pictorialnesses
pitiablenesses1855035p__itiablenesses
pitifulnesses1855555p__itifulnesses
plaintivenesses2054295plaintivenesses
planenesses1349035p_la__nenesses
plausiblenesses1973115plausiblenesses
pleasingnesses1752835pleasingnesses
plentifulnesses2093165plentifulnesses
pliablenesses1756045p_l__iablenesses
pliantnesses1444455p_l__iantnesses
politenesses1448555pol__itenesses
positivenesses1965945positivenesses
pottinesses1339095p_otti__nesses
prettinesses1447515pretti__nesses
pulpinesses1535995pul_pi__nesses
punitivenesses1965625punitivenesses
radicalnesses16124105ra_dicalnesses
rationalnesses1452615rationalnesses
relatednesses1444985relat_ednesses
salaciousnesses1665575salaciousnesses
saltnesses10310165sal_t___nesses
salutarinesses1462775salutarinesses
slavishnesses1843675_slavishnesses
specialnesses1753855_specialnesses
spiritualnesses1782125spiritualnesses
stillnesses1146715___stillnesses
sultanesses1145545sul_t_a_nesses
sweatinesses1546905sweati__nesses
tactfulnesses1855255ta_ctfulnesses
talkinesses1537355tal_ki__nesses
tallnesses1037465tal____lnesses
tartinesses111011495ta_rti__nesses
tastinesses111110775ta_sti__nesses
tattinesses11128945ta_tti__nesses
unlawfulnesses2052985unlawfulnesses
unnaturalnesses1561655unnaturalnesses
valiantnesses1652725val__iantnesses
validnesses1576025val__i_dnesses
venialnesses1555685__venialnesses
verticalnesses1953645_verticalnesses
vitalnesses1456245__vit_alnesses

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 Filter178691950240.1231452772.4
2DLD Change Limit950241497.69012356.8
3Display Results1491490.1061405.7
 (SQL Overall)1786911497.91922564.8
 
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.