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

359 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
maziness1923954(None) 
haziness20248511haziness
laziness17239981laziness
matiness102114741matiness
azines155517072_azine_s
caginess11310302caginess
cakiness1449552cakiness
coziness19319822coziness
craziness2037382craziness
doziness18228552doziness
easiness8313042easiness
foziness20257802foziness
gaminess112911052gaminess
gauziness1934612gauziness
glaziness1935752glaziness
jazziness2432842jazziness
laciness102112552laciness
madness10310072ma_dness
maleness10312312maleness
malines93625602maline_s
maltiness112910572maltiness
manginess122010412manginess
manliness111310122manliness
mariners103113862mariners
marines93928012marine_s
massiness112810142massiness
matinees102110422matinees
mazedness2194572mazedness
maziest183613872mazi_est
mazinesses2139902mazinesses
mealiness11310062mealiness
meatiness11311172meatiness
miriness10310462miriness
mopiness12259062mopiness
muzziness1933142muzziness
ooziness17237512ooziness
raciness102413452raciness
siziness1737422siziness
wariness11313212wariness
waviness1437722waviness
waxiness1836722waxiness
zaniness1738662zaniness
achiness1339703achiness
acidness1136723_acidness
airiness8412213airiness
aliners74717723_aliners
alines65735223_aline_s
amines84727983_amine_s
ammines11312673ammine_s
aptness9268573_aptness
aridness939223_aridness
artiness81615403artiness
ashiness1138963ashiness
avidness1246113_avidness
azides165113803_azide_s
azine146721413_azine__
badness1039573ba_dness
bagginess1355953bagginess
baldness1137043baldness
balkiness1556903balkiness
balminess1356593balminess
bandiness122310243bandiness
bareness10912813bareness
baroness101210063baroness
baseness10910943baseness
basinets1039063basinets
bassness1096743bassness
battiness11239843battiness
bawdiness15235543bawdiness
beadiness12249233beadiness
boniness102211803boniness
booziness20135613booziness
boxiness17247813boxiness
business102110683business
cabinets1238283cabinets
calmness1236643calmness
campiness1537543campiness
canines93724033canine_s
canniness1138643canniness
canoness1039393canoness
cattiness112310633cattiness
chariness14310063chariness
cosiness103214283cosiness
daffiness1634843daffiness
daftness1235533daftness
dailiness1038673dailiness
dampness1336073dampness
dankness13256693dankness
darkness13247343darkness
dazedness20114963dazedness
dewiness1238453dewiness
diazines1838703diazine_s
ditziness1945883ditziness
dizziness1834183dizziness
dopiness11289973dopiness
earliness939693earliness
edginess1036053edginess
eeriness8311873eeriness
emptiness1335373emptiness
fainest10417703fa_inest
fairness1136563fairness
famines123216263famine_s
fanciness1437673fanciness
fanzines2036913fanzine_s
farness102912203fa_rness
fastness11238763fastness
fatness103311293fa_tness
fattiness12239373fattiness
flakiness1636473flakiness
foaminess1437503foaminess
foxiness18257403foxiness
fuzziness2033173fuzziness
gabbiness1434403gabbiness
gainers84214593ga_iners
gainless9117403ga_inless
gameness112810693gameness
gamines103618463gamine_s
gassiness10268313gassiness
gastness9278473gastness
gaudiness1136253gaudiness
gawkiness1734753gawkiness
gayness1136843ga_yness
glariness1038553glariness
gluiness937363gluiness
goriness9310753goriness
grapiness1238243grapiness
hairiness1238013hairiness
haleness11312623haleness
halfness1435563halfness
hamminess1635703hamminess
handiness132110933handiness
happiness1635993happiness
hardiness132310353hardiness
hardness122411083hardness
harness102413933ha_rness
hastiness122410883hastiness
haziest193313003hazi_est
hazinesses2239213hazinesses
hazings20378343hazin_gs
headiness132510363headiness
heaviness15207063heaviness
hoariness1238823hoariness
hokiness152510183hokiness
holiness112512503holiness
hominess132712453hominess
iciness938863_iciness
ickiness1436753ickiness
iffiness1435023iffiness
imaginers1243693imaginers
imagines1137463imagine_s
inkiness1238693inkiness
jokiness19227393jokiness
lameness102612673lameness
lankiness1338053lankiness
lankness12237043lankness
larkiness1338113larkiness
lateness82614073lateness
lawines103313563lawine_s
laxness1436043la_xness
lazies154418783lazi_e_s
laziest163814473lazi_est
lazinesses19310143lazinesses
leafiness1236483leafiness
leakiness1337503leakiness
liminess10510643liminess
loaminess1137493loaminess
loginess9310163loginess
machines15312883machine_s
magazines2145633magazine_s
magnets10311143ma_gnets
maidens10349663ma_idens
maihems1444303ma_ihems
mailers94420333ma_ilers
mailes84329113ma_ile_s
mailless10248583mailless
maimers113813043ma_imers
mains75635103ma_in__s
maizes175115733ma_ize_s
makings145413153makin_gs
malices114316623malice_s
maligners12104783maligners
maline84529083maline__
malingers1285853malingers
mamies104626243mami_e_s
maneless102812343maneless
manes76648953ma__ne_s
manifest1339503manifest
manifests1444123manifests
manless93012933ma_nless
manners93417833ma_nners
manses84225513ma__nses
marinas93519373marin_as
marine84230403marine__
mariner93315993marine_r
marlines103818713marline_s
marquess19204953marquess
marshiness1555063marshiness
martinets1138883martinets
massless10277113massless
mastless102610023mastless
mateless102711293mateless
mateyness1444473mateyness
matiest92522453mati_est
matinee92415613matine_e
matinesses12314523matinesses
matings104516203matin_gs
matins84527783matin__s
matless93014043ma_tless
mattress1036533mattress
mavies114923193mavi_e_s
mavins115119183mavin__s
mavises122812993mavise_s
maxixes1535253maxixe_s
mayings134410503mayin_gs
mayoress1344383mayoress
mazers173917093maz__ers
mazes165632173maz__e_s
mazier175013063mazi_e_r
mazing184418973mazin__g
meanness1037183meanness
meekness1434303meekness
meetness1036653meetness
merriness1138283merriness
messiness11248223messiness
miffiness1734523miffiness
mildness1136523mildness
milkiness1536523milkiness
miners84126633m__iners
mines75651953m__ine_s
mistiness111911633mistiness
moldiness12227053moldiness
moodiness12197593moodiness
mooniness11157863mooniness
mootness1036753mootness
moreness10911573moreness
mossiness11258323mossiness
mousiness11219023mousiness
muchness1534073muchness
muddiness1334753muddiness
mugginess1354633mugginess
murines93718223murine_s
murkiness15206283murkiness
mushiness14248213mushiness
muskiness15237433muskiness
mussiness11238293mussiness
mustiness112211653mustiness
muteness1039013muteness
mutines93117823mutine_s
nappiness1335233nappiness
nastiness92310573nastiness
nattiness9239333nattiness
nosiness83211393nosiness
oiliness8311563oiliness
oxazines2434073oxazine_s
packness1636933packness
painless10108343pa_inless
paleness10312983paleness
pastiness112312353pastiness
pastness102510503pastness
patines95225763patine_s
patness92912283pa_tness
pawkiness1835443pawkiness
pipiness1238003pipiness
pixiness1736093pixiness
pokiness14219863pokiness
puniness101610273puniness
quakiness2236073quakiness
rabidness12145263rabidness
raininess949273raininess
rainless8129703ra_inless
randiness102511443randiness
ranginess101610213ranginess
rankness12267943rankness
rapidness12155473rapidness
rapines95120863rapine_s
raptness1046733raptness
rareness81112853rareness
rashness1138093rashness
raspiness1137303raspiness
ratines75328583ratine_s
ravines104220233ravine_s
rawness1038153ra_wness
readiness102611853readiness
riminess10510093riminess
ritziness1835823ritziness
ropiness102311073ropiness
rosiness82613173rosiness
sabines94318483sabine_s
sadness8310613sa_dness
safeness11239633safeness
sageness92111983sageness
salines74029413saline_s
saltiness93312113saltiness
saltness82610243saltness
sameness102712683sameness
sandiness102111713sandiness
saneness82313723saneness
sappiness1337433sappiness
sassiness8249333sassiness
satinets8311733satinets
sauciness1138043sauciness
savines104417633savine_s
savviness1534713savviness
scaliness1149303scaliness
scariness11310183scariness
seaminess11310473seaminess
sexiness1537943sexiness
shadiness1337463shadiness
shakiness1637083shakiness
simazines2044863simazine_s
slatiness92511363slatiness
sleaziness19104703sleaziness
smallness1174513smallness
smarminess1444303smarminess
smartness1136143smartness
smokiness1535543smokiness
snakiness1367473snakiness
soapiness1138293soapiness
sozines16611263sozine_s
spaciness1337083spaciness
staginess1038753staginess
tacitness1134873tacitness
tackiness1557693tackiness
talkiness1356913talkiness
tallness837103tallness
tameness102411253tameness
tanginess10239283tanginess
tardiness10229913tardiness
tarriness9229243tarriness
tartiness92112053tartiness
tartness82210133tartness
tastiness92311143tastiness
tattiness9239413tattiness
tautness8217183tautness
tawniness1245123tawniness
teariness9310633teariness
tidiness938793tidiness
tininess8310633tininess
ugliness936863ugliness
vahines133410523vahine_s
vainest10315763va_inest
vainness1136063vainness
validness13125363validness
valines104520213valine_s
vapidness15144423vapidness
vastness11257293vastness
wackiness1836523wackiness
waeness102512783wa_eness
wahines133111173wahine_s
wanness102610683wa_nness
warmness1337063warmness
washiness1537043washiness
waspiness1435793waspiness
weariness1238843weariness
wiliness1139113wiliness
wiriness1138953wiriness
wooziness21125213wooziness
zinebs17606803__zinebs
zines145232653__zine_s

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623597.50019488.3
3Display Results3593590.1432510.5
 (SQL Overall)1786913597.79922912.0
 
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.