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

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

93 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
smarminess144430(None) 
scariness11310182scar_iness
seaminess11310472sea_miness
smarmiest1335912smarmi_est
smarminesses1645102smarminesses
smartness1136142smar_tness
storminess1245212storminess
artiness81615413__artiness
balminess1356593_balminess
carmines123617873_carmine_s
chariness14310063char_iness
clamminess1643613clamminess
earliness939693_earliness
foaminess1437503foa_miness
gaminess112911063_ga_miness
germiness1257693_germiness
glariness1038553glar_iness
hamminess1635713_hamminess
hardiness132310363_hardiness
harmines132715143_harmine_s
heartiness1338033heartiness
hoariness1238823hoar_iness
larkiness1338113_larkiness
loaminess1137493loa_miness
maltiness112910573_maltiness
manginess122010413_manginess
manliness111310123_manliness
mariners103113863_mar_iners
marines93928013_mar_ine_s
marlines103818723_marline_s
marmites122212793_marmite_s
marshiness1555063_marshiness
martinets1138883_martinets
massiness112810143_massiness
matiness102114753_ma_tiness
maziness19239543_ma_ziness
merriness1138293_merriness
miriness10310463_mir_iness
murkiness15206293_murkiness
saltiness93312113s_altiness
sameness102712683s_a_meness
sandiness102111713s_andiness
sappiness1337443s_appiness
sardines92815573s_ardine_s
sassiness8249333s_assiness
sauciness1138043s_auciness
savviness1534713s_avviness
scaliness1149303sca_liness
scantiness1236883scantiness
scarceness1444763scarceness
scurviness1543283scurviness
shabbiness1743133shabbiness
shadiness1337463sha_diness
shagginess1543933shagginess
shakiness1637083sha_kiness
sharpness1434943shar_pness
slanginess1146273slanginess
slatiness92511363sla_tiness
sliminess1137423s_liminess
smallness1174513sma_llness
smaltines1136993smaltine_s
smarmier1235033smarmi_e_r
smarties10312873smarti_e_s
smokiness1535543sm_okiness
smudginess1442873smudginess
smuttiness1244403smuttiness
snakiness1367473sna_kiness
snappiness1443833snappiness
soapiness1138293soa_piness
sorriness939583s_orriness
spaciness1337083spa_ciness
spareness1139863spar_eness
sparseness1245493sparseness
spermines13310543spermine_s
sportiness1278233sportiness
staginess1038753sta_giness
starchiness1643943starchiness
starkness1335963star_kness
steaminess1236773steaminess
sturdiness1144843sturdiness
surliness939943s_urliness
swampiness1773353swampiness
swankiness1744253swankiness
swarthiness1743383swarthiness
swartness1236113swar_tness
tardiness10229923_tardiness
tarriness9229243_tarriness
tartiness92112053_tartiness
teariness9310633tear_iness
wariness11313213_war_iness
warmness1337063_warm_ness
weariness1238843wear_iness
worminess14127613_worminess

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 Filter1786911406030.406440125.6
2DLD Change Limit140603935.79624258.6
3Display Results93930.0462021.7
 (SQL Overall)178691936.24828599.7
 
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.