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

255 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
earliness93969(None) 
artiness81615402_artiness
burliness1137832burliness
carlines103521642carline_s
curliness1138552curliness
dailiness1038672dailiness
deadliness12115892deadliness
earless74316072earl__ess
earliest82415242earli_est
earlinesses11311032earlinesses
earthiness1377242earthiness
earthliness14144142earthliness
earwitness1342622earwitness
easiness8313042ea_siness
eeriness8311872eer_iness
hardiness132310352hardiness
heartiness1338032heartiness
larkiness1338112larkiness
manliness111310122manliness
marlines103818712marline_s
mealiness11310062mea_liness
surliness939942surliness
tardiness10229912tardiness
tarriness9229242tarriness
tartiness92112052tartiness
teariness9310632tear_iness
wariness11313212war_iness
weakliness1753852weakliness
weariness1238842wear_iness
achiness1339703_achiness
airiness8412213_airiness
airliners945983airliners
airlines8312793airline_s
aliners74717723_a_liners
alines65735223_a_line_s
archness1337513_archness
aridness939223_aridness
arsines73518813_arsine_s
artsiness937653_artsiness
ashiness1138963_ashiness
bagginess1355953bagginess
baldness1137043ba_ldness
balkiness1556903balkiness
balminess1356593balminess
bandiness122310243bandiness
bareness10912813bar_eness
barless94317003barl__ess
baroness101210063bar_oness
battiness11239843battiness
bawdiness15235543bawdiness
beadiness12249233bea_diness
beastliness1343333beastliness
beeriness1137863beer_iness
beggarliness1651323beggarliness
berlines102315453berline_s
bleariness1246053blear_iness
caginess11310303ca_giness
cakiness1449553ca_kiness
calmness1236643ca_lmness
campiness1537543campiness
canniness1138643canniness
carbines123617533carbine_s
carless95118493carl__ess
carline93923613carline__
carlings114015853carlin_gs
carlins93921913carlin__s
carmines123617863carmine_s
cattiness112310633cattiness
chariness14310063char_iness
cleanliness1343263cleanliness
corkiness152810443corkiness
corniness112611183corniness
craziness2037383craziness
daffiness1634843daffiness
dailyness1343643dailyness
darkness13247343dar_kness
darlingness1373263darlingness
darlings103710383darlin_gs
deadlines11138493deadline_s
dearness939973dear__ness
dirtiness1039463dirtiness
dorkiness14248053dorkiness
dreariness1146283drear_iness
eagerness1046263eagerness
eanlings9128473eanlin_gs
earings84517703ear_in_gs
earlier72612743earli_e_r
earlobes1056143earlobe_s
earners74016453ear__ners
earnest7318733ear__nest
earnests837853ear__nests
earnings9419323earnin_gs
earrings9299623earrin_gs
edginess1036053e_dginess
elderliness1242853elderliness
emptiness1335373emptiness
ermines9416663e_rmine_s
errhines1136403errhine_s
evilness1135043evil_ness
eyeliners1264063eyeliners
fanciness1437673fanciness
farness102912203far__ness
fattiness12239373fattiness
faultiness1344823faultiness
fearless1137873fearl__ess
forkiness16268703forkiness
frailness1236533frailness
furriness12287593furriness
gabbiness1434403gabbiness
gaminess112911053ga_miness
gassiness10268313gassiness
gaudiness1136253gaudiness
gauziness1934613gauziness
gawkiness1734753gawkiness
gearless937373gearl__ess
germiness1257693germiness
glariness1038553glar_iness
godliness1136593godliness
goriness9310753gor_iness
grapiness1238243grapiness
hairiness1238013hairiness
hairlines1237133hairline_s
haleness11312623ha_leness
halfness1435563ha_lfness
hamminess1635703hamminess
handiness132110933handiness
happiness1635993happiness
hardness122411083har_dness
harmines132715143harmine_s
harness102413933har__ness
harshness1545963harshness
hastiness122410883hastiness
haziness20248513ha_ziness
headiness132510363hea_diness
headliners14144333headliners
headlines13119003headline_s
heaviness15207063hea_viness
hilliness1248923hilliness
hoariness1238823hoar_iness
holiness112512503_holiness
horniness12309143horniness
horsiness12259463horsiness
jawlines18126363jawline_s
jazziness2432843jazziness
jerkiness20175643jerkiness
jolliness1636213jolliness
jowliness1934853jowliness
kaolines1239293kaoline_s
laciness102112553la_ciness
lankiness1338053lankiness
largeness1038273largeness
laziness17239983la_ziness
leafiness1236483lea_finess
leakiness1337503lea_kiness
leeriness938323leer_iness
lordliness1144883lordliness
lowliness1236403lowliness
maleness10312313ma_leness
malines93625603ma_line_s
maltiness112910573maltiness
manginess122010413manginess
mariners103113863mar_iners
marines93928013mar_ine_s
marliest102415183marli_est
marline93320953marline__
marlings113713483marlin_gs
marlins93420473marlin__s
marlites103415263marlite_s
marshiness1555063marshiness
martinets1138883martinets
massiness112810143massiness
matiness102114743ma_tiness
maziness19239543ma_ziness
meatiness11311173mea_tiness
merriness1138283merriness
miriness10310463mir_iness
murkiness15206283murkiness
nappiness1335233nappiness
nastiness92310573nastiness
nattiness9239333nattiness
nearliest949353nearli_est
nearness838313near__ness
nerdiness10208333nerdiness
nerviness12226873nerviness
oarless73913373oarl__ess
oiliness8311563_oiliness
paleness10312983pa_leness
pallidness1343283pallidness
pastiness112312353pastiness
pawkiness1835443pawkiness
pearliest1139353pearli_est
pearlites1138233pearlite_s
peartness1137773pear_tness
perkiness15209163perkiness
porkiness15249193porkiness
portliness1246833portliness
pralines102217723praline_s
purlines103514053purline_s
pursiness1138453pursiness
raciness102413453ra_ciness
raininess949273raininess
randiness102511443randiness
ranginess101610213ranginess
rareness81112853rar_eness
raspiness1137303raspiness
ratlines83815293ratline_s
readiness102611853rea_diness
realness8410443rea_l_ness
salines74029413sa_line_s
saltiness93312113saltiness
saltness82610243sa_ltness
sandiness102111713sandiness
sappiness1337433sappiness
sardines92815563sardine_s
sassiness8249333sassiness
sauciness1138043sauciness
savviness1534713savviness
scaliness1149303scaliness
scariness11310183scar_iness
seaminess11310473sea_miness
seemliness1244153seemliness
silliness9510353silliness
smarminess1444303smarminess
sorriness939583sorriness
tackiness1557693tackiness
taglines92210833tagline_s
talkiness1356913talkiness
tallness837103ta_llness
tanginess10239283tanginess
tartness82210133tar_tness
tastiness92311143tastiness
tattiness9239413tattiness
tawniness1245123tawniness
tearless848713tearl__ess
ugliness936863_ugliness
unruliness1044633unruliness
validness13125363va_lidness
valines104520213va_line_s
wackiness1836523wackiness
warless104015103warl__ess
warmness1337063war_mness
washiness1537043washiness
waspiness1435793waspiness
waviness1437723wa_viness
waxiness1836723wa_xiness
weariless1234763wear_iless
wiliness1139113_wiliness
wiriness1138953wir_iness
wooliness12147693wooliness
wordiness13138633wordiness
worminess14127613worminess
yearlies1137603yearli_e_s
yearlings1384193yearlin_gs
yeastiness1344883yeastiness
zaniness1738663za_niness

Search took 10 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.1731032896.0
2DLD Change Limit1486412559.04616431.7
3Display Results2552550.1232073.2
 (SQL Overall)1786912559.34219127.7
 
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.