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

232 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
dailiness103867(None) 
dailyness1343641dailyness
airiness8412212_airiness
daffiness1634842daffiness
dailies84219262daili_e_s
dailinesses1249492dailinesses
daintiness1145962daintiness
deadliness12115892deadliness
earliness939692earliness
hairiness1238012hairiness
manliness111310122manliness
oiliness8311562_oiliness
raininess949272raininess
wiliness1139112_wiliness
achiness1339703_achiness
adultness1043973adultness
agileness1046493agileness
airliners945983_airliners
airlines8312793_airline_s
aliners74717723_a_liners
alines65735223_a_line_s
anilines8415143aniline_s
artiness81615403_artiness
ashiness1138963_ashiness
bagginess1355953bagginess
bailies94120203baili_e_s
baldness1137043ba_ldness
balkiness1556903balkiness
balminess1356593balminess
bandiness122310243bandiness
battiness11239843battiness
bawdiness15235543bawdiness
braininess1246123braininess
brininess1138203brininess
burliness1137833burliness
caginess11310303ca_giness
cakiness1449553ca_kiness
calmness1236643ca_lmness
campiness1537543campiness
canniness1138643canniness
carlines103521643carline_s
cattiness112310633cattiness
chilliness1555313chilliness
chillness1455373chillness
curliness1138553curliness
daftness1235533da_ftness
dailynesses1543943dailynesses
daimones11208803daimone_s
dairies84217733dairi_e_s
daisies84217093daisi_e_s
dalliers93610613dalli_ers
dallies84023193dalli_e_s
dampness1336073da_mpness
dankness13256693da_nkness
daringness1244743daringness
darkness13247343da_rkness
darlingness1373263darlingness
darlings103710383darlin_gs
datedness1187753datedness
datelines1088843dateline_s
dazedness20114963dazedness
deadlines11138483deadline_s
decliners12358613decliners
declines113315793decline_s
dewiness1238453d_ewiness
diakineses1543693diakineses
diakinesis1542733diakinesis
dialings10329823dialin_gs
diamines11311623diamine_s
diazines1838703diazine_s
dimness1038843d_i_mness
dinginess1137823dinginess
dippiness1435973dippiness
direness9311303d_ireness
dirtiness1039463dirtiness
ditsiness1048133ditsiness
ditziness1945883ditziness
diviners12308353d_iviners
divines113514723d_ivine_s
divinest123012173d_ivinest
dizziness1834183dizziness
dodginess1235283dodginess
doilies84017363doili_e_s
dopiness11289973d_opiness
dorkiness14248053dorkiness
dottiness1058043dottiness
dowdiness1485693dowdiness
downiness13106713downiness
doziness18228553d_oziness
draftiness1444853draftiness
draglines1145993dragline_s
drollness1043623drollness
dullness934873d_ullness
dulness8307983d_ul_ness
dumpiness1435653dumpiness
duskiness14216673duskiness
dustiness102211023dustiness
easiness8313043ea_siness
evilness1135043evil_ness
facileness1545503facileness
failings123811013failin_gs
faintness1235833faintness
fairness1136563fai_rness
fanciness1437673fanciness
fattiness12239373fattiness
faultiness1344823faultiness
filminess1435983_filminess
frailness1236533frail_ness
gabbiness1434403gabbiness
gaminess112911053ga_miness
gassiness10268313gassiness
gaudiness1136253gaudiness
gauziness1934613gauziness
gawkiness1734753gawkiness
godliness1136593godliness
graininess1145783graininess
griminess1236693griminess
grisliness1155143grisliness
guiltiness1144193guiltiness
hairlines1237133hairline_s
haleness11312623ha_leness
halfness1435563ha_lfness
hamminess1635703hamminess
handiness132110933handiness
happiness1635993happiness
hardiness132310353hardiness
hastiness122410883hastiness
haziness20248513ha_ziness
hilliness1248923hilliness
holiness112512503_holiness
iciness938863__iciness
illness736473__illness
jawlines18126363jawline_s
jazziness2432843jazziness
jolliness1636213jolliness
jowliness1934853jowliness
juiciness1835153juiciness
kaolines1239293kaoline_s
laciness102112553la_ciness
lankiness1338053lankiness
larkiness1338113larkiness
laziness17239983la_ziness
liminess10510643_liminess
lowliness1236403lowliness
mailings113011923mailin_gs
mailless10248583mail_less
mainliners1243993mainliners
mainlines1138513mainline_s
maleness10312313ma_leness
malines93625603ma_line_s
maltiness112910573maltiness
manginess122010413manginess
marlines103818713marline_s
massiness112810143massiness
matiness102114743ma_tiness
maziness19239543ma_ziness
mealiness11310063mealiness
mildness1136523_mildness
milkiness1536523_milkiness
miriness10310463_miriness
naiveness1277483naiveness
nappiness1335233nappiness
nastiness92310573nastiness
nattiness9239333nattiness
noisiness948343noisiness
paleness10312983pa_leness
pallidness1343283pallidness
pastiness112312353pastiness
pawkiness1835443pawkiness
pipiness1238003_pipiness
pixiness1736093_pixiness
raciness102413453ra_ciness
railings93412153railin_gs
randiness102511443randiness
ranginess101610213ranginess
raspiness1137303raspiness
ratlines83815293ratline_s
riminess10510093_riminess
sailings93513253sailin_gs
sailless82410363sail_less
saintliness1144153saintliness
salines74029413sa_line_s
saltiness93312113saltiness
saltness82610243sa_ltness
sandiness102111713sandiness
sappiness1337433sappiness
sassiness8249333sassiness
sauciness1138043sauciness
savviness1534713savviness
scaliness1149303scaliness
shininess1237333shininess
silkiness1337253_silkiness
silliness9510353silliness
siziness1737423_siziness
sliminess1137423sliminess
spiciness1347053spiciness
spikiness1536313spikiness
spininess1137963spininess
stillness936093stillness
surliness939943surliness
tackiness1557693tackiness
taglines92210833tagline_s
tailings93211673tailin_gs
tailless8239083tail_less
talkiness1356913talkiness
tallness837103ta_llness
tanginess10239283tanginess
tardiness10229913tardiness
tarriness9229243tarriness
tartiness92112053tartiness
tastiness92311143tastiness
tattiness9239413tattiness
tawniness1245123tawniness
tidiness938793_tidiness
tininess8310633_tininess
ugliness936863_ugliness
vainness1136063vai_nness
validness13125363validness
valines104520213va_line_s
vileness1139983_vileness
wackiness1836523wackiness
wariness11313213wa_riness
washiness1537043washiness
waspiness1435793waspiness
waviness1437723wa_viness
waxiness1836723wa_xiness
weakliness1753853weakliness
whininess1535123whininess
wildness1236203_wildness
wiriness1138953_wiriness
wooliness12147693wooliness
zaniness1738663za_niness

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.186960704.3
2DLD Change Limit1486412327.04621095.8
3Display Results2322320.1102109.1
 (SQL Overall)1786912327.34224338.2
 
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.