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

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

260 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
scariness1131018(None) 
scaliness1149301scaliness
acarines10314342acarine_s
caginess11310302_caginess
cakiness1449552_cakiness
chariness14310062chariness
glariness1038552glariness
hoariness1238822hoariness
scantiness1236882scantiness
scantness1135732scantness
scarceness1444762scarceness
scariest101615942scari_est
scarinesses1339902scarinesses
scarless10189052scar_less
scurviness1543282scurviness
seaminess11310472seaminess
shadiness1337462shadiness
shakiness1637082shakiness
sharpness1434932sharpness
slatiness92511362slatiness
smarminess1444302smarminess
smartness1136142smartness
snakiness1367472snakiness
soapiness1138292soapiness
sorriness939582sorriness
spaciness1337082spaciness
spareness1139862spareness
staginess1038752staginess
starkness1335962starkness
swartness1236112swartness
teariness9310632teariness
wariness11313212_wariness
weariness1238842weariness
acariases1146613acariases
acarine9316003acarine__
achiness1339703ac_hiness
acridness1245073ac_ridness
airiness8412213_airiness
angriness1036453angriness
apartness1146053apartness
aridness939223__aridness
artiness81615403__artiness
ascariases1244233ascariases
ascarides12346953ascaride_s
awareness1236343awareness
bareness10912813_bareness
baroness101210063_baroness
beadiness12249233beadiness
beeriness1137863beeriness
bleariness1246053bleariness
cabinets1238283_cabinets
calmness1236643_calmness
campiness1537543_campiness
canines93724033_canine_s
canniness1138643_canniness
canoness1039393_canoness
carbines123617533_carbine_s
careless102813633_careless
caress85720263_car__ess
caribes113715643_caribe_s
carices114220953_carice_s
caries85147623_cari_e_s
carinas93622403_carin_as
carless95118493_car_less
carlines103521643_carline_s
carmines123617863_carmine_s
carnets93918403_car_nets
carneys124310543_car_neys
carnies94123963_carnie_s
cattiness112310633_cattiness
clarinets1137683clarinets
corkiness152810443_corkiness
corniness112611183_corniness
cosiness103214283_cosiness
coziness19319823_coziness
craziness2037383craziness
curliness1138553_curliness
curtness1037263_curtness
darkness13247343_darkness
dearness939973dear_ness
dreariness1146283dreariness
dwarfness1642793dwarfness
earliness939693_earliness
easiness8313043_easiness
eeriness8311873_eeriness
fairness1136563_fairness
farness102912203_far_ness
fieriness1238623fieriness
flakiness1636473flakiness
foaminess1437503foaminess
furriness12287603furriness
gaminess112911063_gaminess
glaziness1935753glaziness
goriness9310753_goriness
grapiness1238253grapiness
hairiness1238013hairiness
hardiness132310353_hardiness
hardness122411083_hardness
harness102413933_har_ness
haziness20248513_haziness
headiness132510363headiness
heartiness1338033heartiness
heaviness15207063heaviness
iciness938863ic__iness
ickiness1436753ic_kiness
laciness102112553_laciness
larkiness1338113_larkiness
laziness17239983_laziness
leafiness1236483leafiness
leakiness1337503leakiness
leeriness938323leeriness
loaminess1137493loaminess
mariners103113863_mariners
marines93928013_marine_s
matiness102114753_matiness
maziness19239543_maziness
mealiness11310063mealiness
meatiness11311183meatiness
merriness1138293merriness
miriness10310463_miriness
muscarines1445393muscarine_s
nearness838313near_ness
ocarinas1036723ocarin_as
peartness1137773peartness
quakiness2236073quakiness
raciness102413453_raciness
rareness81112853_rareness
readiness102611853readiness
sabines94318483s_abine_s
sacredness1344543sacredness
sacrings11278923sacrin_gs
sadness8310613s_a_dness
safeness11239633s_afeness
sageness92111983s_ageness
salines74029413s_aline_s
saltiness93312113saltiness
saltness82610243s_altness
sameness102712683s_ameness
sandiness102111713sandiness
saneness82313723s_aneness
sappiness1337433sappiness
sardines92815563s_ardine_s
sarins63932623s_arin__s
sarsnets836783s_arsnets
sassiness8249333sassiness
satinets8311733s_atinets
sauciness1138043sauciness
savines104417633s_avine_s
savoriness1354933savoriness
savviness1534713savviness
scabies11613333scabi_e_s
scaleless1135513scaleless
scaliest101714393scali_est
scalinesses1339323scalinesses
scanners10379703sca_nners
scarcest12169173scar_cest
scaredest1246633scaredest
scarers94618513scar__ers
scares85033003scar__e_s
scarfers13408463scar_fers
scarier94017873scari_e_r
scarifiers1544103scarifiers
scarifies1439603scarifies
scaring103421973scarin__g
scariose1037593scari_ose
scarious10610203scari_ous
scarlets10178573scar_lets
scarpers124712513scar_pers
scarriest11188393scarriest
scarves124511623scar_ve_s
sciurines1144683sciurine_s
scoreless1155603scoreless
scorners10228493scor_ners
scrannels1143513scrannels
scrappiness1752283scrappiness
scrawniness1652153scrawniness
screwiness1544413screwiness
scribers12307963sc_ribers
scribes113713203sc_ribe_s
scries85226823sc_ri_e_s
scrives124414273sc_rive_s
secureness1245053secureness
seediness10219173seediness
serines74229543s_erine_s
sexiness1537943s_exiness
shabbiness1743133shabbiness
shagginess1543933shagginess
shininess1237333shininess
shortness1236733shortness
showiness1576073showiness
shrines104618693s_hrine_s
sickliness1645003sickliness
silkiness1337253silkiness
silliness9510363silliness
sissiness8217963sissiness
siziness1737423s_iziness
slackness1535433slackness
slanginess1146273slanginess
sleaziness19104703sleaziness
sliminess1137423sliminess
smallness1174513smallness
smokiness1535543smokiness
snappiness1443823snappiness
sneakiness1454873sneakiness
snowiness1296243snowiness
soarings93210393soarin_gs
sogginess1136183sogginess
sootiness999833sootiness
soppiness1336543soppiness
soreness8914793s_oreness
sourness839543sour_ness
sparseness1245493sparseness
spiciness1347053spiciness
spikiness1536313spikiness
spininess1137963spininess
sportiness1278233sportiness
spryness1334003s_pryness
squareness1944763squareness
staidness1037033staidness
stainers83212173sta_iners
stainless9176493sta_inless
stairless9185623stairless
staleness9310783staleness
stanines85115673stanine_s
starchiness1643943starchiness
starless81610843star_less
steadiness1146703steadiness
steaminess1236773steaminess
stearines9311283stearine_s
sternness946093sternness
stoniness938343stoniness
storminess1245213storminess
strainers9510383strainers
straitness1046293straitness
sturdiness1144843sturdiness
suaveness1247703suaveness
sulkiness1347353sulkiness
sultriness1045563sultriness
sunniness9247943sunniness
sureness8912903s_ureness
surliness939943surliness
swampiness1773353swampiness
swankiness1744253swankiness
swarthiness1743383swarthiness
sweatiness1336463sweatiness
sycamines1645523sycamine_s
tackiness1557693tackiness
tacrines10310563tacrine_s
tardiness10229913_tardiness
tarriness9229243tarriness
tartiness92112053_tartiness
tartness82210133_tartness
unwariness1365883unwariness
wackiness1836523wackiness
warmness1337063_warmness
waviness1437723_waviness
waxiness1836723_waxiness
weariless1234763weariless
wiriness1138953_wiriness
zaniness1738663_zaniness

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 Filter1786911486410.436409841.7
2DLD Change Limit1486412607.03021143.8
3Display Results2602600.1601625.0
 (SQL Overall)1786912607.62623431.8
 
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.