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

224 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
weariness123884(None) 
teariness9310631teariness
wariness11313211w_ariness
weariless1234761weariless
beadiness12249232beadiness
beeriness1137862beeriness
bleariness1246052bleariness
chariness14310062chariness
dearness939972dear_ness
dreariness1146282dreariness
earliness939692_earliness
easiness8313042_easiness
eeriness8311872_eeriness
glariness1038552glariness
headiness132510362headiness
heartiness1338032heartiness
heaviness15207062heaviness
hoariness1238822hoariness
leafiness1236482leafiness
leakiness1337502leakiness
leeriness938322leeriness
mealiness11310062mealiness
meatiness11311182meatiness
merriness1138292merriness
nearness838312near_ness
peartness1137772peartness
readiness102611852readiness
scariness11310182scariness
seaminess11310472seaminess
sweatiness1336462sweatiness
warmness1337062w_armness
waviness1437722w_aviness
waxiness1836722w_axiness
weakliness1753852weakliness
weakness1535352wea_kness
wearies103020222weari_e_s
weariest112914792weari_est
wearinesses14310212wearinesses
weediness13247042weediness
weepiness14215962weepiness
weirdness1343592weirdness
wiriness1138952w_iriness
acarines10314343acarine_s
airiness8412213_airiness
angriness1036453angriness
apartness1146053apartness
aridness939223__aridness
artiness81615403__artiness
awareness1236343awareness
bareness10912813_bareness
baroness101210063_baroness
beardless1234913beardless
bearings113912253bearin_gs
bearishness1644543bearishness
beefiness1435583beefiness
caginess11310303_caginess
cakiness1449553_cakiness
cheeriness1545533cheeriness
clarinets1137683clarinets
clearness1135633clear_ness
craziness2037383craziness
creakiness1645963creakiness
creaminess1446203creaminess
darkness13247343_darkness
deaconess1245543deaconess
deadliness12115893deadliness
deadness1039233dea_dness
deafness1236213dea_fness
dearies83526273deari_e_s
dewiness1238453de_winess
dreaminess1345313dreaminess
dwarfness1642793dwarfness
earings84517713_earin_gs
earless74316073_ear_less
earners74016453_ear_ners
earnest7318733_ear_nest
earnests837853_ear_nests
earthiness1377243_earthiness
earwitness1342623_earwitness
edginess1036053_edginess
fairness1136563_fairness
farness102912203_far_ness
fearless1137873fear_less
fieriness1238623fieriness
flakiness1636473flakiness
foaminess1437503foaminess
freakiness1745183freakiness
furriness12287603furriness
gaminess112911063_gaminess
gearings10359503gearin_gs
gearless937373gear_less
geekiness1435413geekiness
gemminess1464643gemminess
germiness1257693germiness
glaziness1935753glaziness
goriness9310753_goriness
grapiness1238253grapiness
greasiness1156543greasiness
hairiness1238013hairiness
hardiness132310363_hardiness
hardness122411083_hardness
harness102413933_har_ness
haziness20248513_haziness
hearings123611853hearin_gs
heartless1236393heartless
heftiness1536313heftiness
jerkiness20175643jerkiness
jettiness1675693jettiness
laciness102112553_laciness
larkiness1338113_larkiness
laziness17239983_laziness
leanness837373lea_nness
leariest83117853leari_est
learners8398153lear_ners
legginess1135033legginess
loaminess1137493loaminess
mariners103113863_mariners
marines93928013_marine_s
matiness102114753_matiness
maziness19239543_maziness
meanness1037183mea_nness
messiness11248223messiness
miriness10310463_miriness
neatness839153nea_tness
neediness10227733neediness
nerdiness10208333nerdiness
nerviness12226873nerviness
neurines8311193neurine_s
newsiness1236033newsiness
peppiness1235183peppiness
perkiness15209163perkiness
pertness10310093pe_rtness
peskiness15216523peskiness
pettiness1178703pettiness
quakiness2236073quakiness
queasiness1943553queasiness
raciness102413453_raciness
rareness81112853_rareness
realness8410443rea_lness
reediness10239613reediness
scaliness1149303scaliness
seediness10219173seediness
serines74229543se_rine_s
sexiness1537943se_xiness
shadiness1337463shadiness
shakiness1637083shakiness
sharpness1434943sharpness
slatiness92511363slatiness
sleaziness19104703sleaziness
smarminess1444303smarminess
smartness1136143smartness
snakiness1367473snakiness
sneakiness1454873sneakiness
soapiness1138293soapiness
sorriness939583sorriness
spaciness1337083spaciness
spareness1139863spareness
staginess1038753staginess
starkness1335963starkness
steadiness1146703steadiness
steaminess1236773steaminess
stearines9311283stearine_s
swartness1236113swartness
tardiness10229923_tardiness
tarriness9229243tarriness
tartiness92112053_tartiness
tartness82210133_tartness
teariest82417263teari_est
tearinesses11311693tearinesses
tearless848713tear_less
terrines82117553terrine_s
testiness9209753testiness
tweediness1443173tweediness
uneasiness1046393uneasiness
unwariness1365883unwariness
wackiness1836523wackiness
waeness102512783w_a_eness
wahines133111173w_ahine_s
wanness102610683w_a_nness
wardless12249303w_ardless
wardress12256163w_ardress
wariest105122503w_ari_est
warinesses131514523w_arinesses
warless104015103w_ar_less
warners103315563w_ar_ners
wartless11279923w_artless
washiness1537043washiness
waspiness1435793waspiness
wateriness1348073wateriness
weakeners1644163weakeners
wealthiness1742853wealthiness
weaners104613833wea__ners
weaponless1542003weaponless
wearers104615903wear__ers
wearied112911803weari_e_d
wearier103613283weari_e_r
wearifulness1854803wearifulness
wearilessly1752173wearilessly
wearing113318863wearin__g
wearingly1636413wearingly
wearish132310153weari__sh
weiners103913063we__iners
wellness1135793we_llness
wetness10277723we__tness
whatness1435093wha_tness
wheeziness2542543wheeziness
whininess1535123whininess
wiliness1139113w_iliness
wimpiness1635293wimpiness
windiness1337373windiness
wintriness1345543wintriness
wispiness1435633wispiness
wittiness12197223wittiness
woodiness13147873woodiness
wooliness12147693wooliness
wooziness21125213wooziness
wordiness13138633wordiness
worminess14127613worminess
wornness1136363w_ornness
wryness13113983w__ryness
yearners11346373year_ners
yeastiness1344883yeastiness
zaniness1738663_zaniness
zebrines1935883zebrine_s

Search took 9 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.440406115.9
2DLD Change Limit1486412248.34317816.3
3Display Results2242240.1102036.4
 (SQL Overall)1786912248.89320093.4
 
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.