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

243 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
mistiness11191163(None) 
mustiness112211661mustiness
bittiness11228332bittiness
bustiness111810472bustiness
dirtiness1039472dirtiness
ditsiness1048142ditsiness
dustiness102211032dustiness
feistiness1345072feistiness
fishiness1537342fishiness
fustiness121910242fustiness
gustiness10189892gustiness
hastiness122410882hastiness
lustiness92010452lustiness
maltiness112910572maltiness
massiness112810142massiness
matiness102114752m_atiness
meatiness11311182meatiness
messiness11248222messiness
miffiness1734522miffiness
mightiness1645092mightiness
milkiness1536522milkiness
miriness10310462mi_riness
mistiest103018312misti_est
mistimes12612612mistime_s
mistinesses131310622mistinesses
mistress10310702mist_ress
mistunes10311132mistune_s
moistness1146342moist_ness
mossiness11258322mossiness
mushiness14248222mushiness
muskiness15237442muskiness
mussiness11238302mussiness
nastiness92310572nastiness
niftiness1236362niftiness
pastiness112312352pastiness
riskiness1336962riskiness
rustiness92111932rustiness
sissiness8217962sissiness
tastiness92311142tastiness
testiness9209752testiness
wispiness1435632wispiness
wittiness12197222wittiness
airiness8412213ai_riness
antsiness937843antsiness
artiness81615403_artiness
artsiness937653artsiness
ashiness1138963_ashiness
battiness11239843battiness
boskiness15196513boskiness
bossiness11257423bossiness
bushiness14177763bushiness
business102110693bus_iness
cattiness112310633cattiness
cosiness103214283cos_iness
costliness1245993costliness
crispiness1444793crispiness
crustiness1237293crustiness
cushiness14197183cushiness
cystines1339473cystine_s
daintiness1145963daintiness
destines93619663destine_s
dinginess1137823dinginess
dippiness1435973dippiness
distress9311713dist_ress
ditziness1945883ditziness
dizziness1834183dizziness
dottiness1058043dottiness
duskiness14216683duskiness
easiness8313043eas_iness
emptiness1335373emptiness
fastness11238763fast_ness
fattiness12239373fattiness
fieriness1238623fieriness
filminess1435983filminess
filthiness1643713filthiness
firstness1245013first_ness
fitness10299393fi_t_ness
flintiness1345893flintiness
friskiness1744453friskiness
frostiness1336563frostiness
fussiness12226583fussiness
gassiness10268313gassiness
gastness9278473gast_ness
giddiness1234683giddiness
goutiness1038763goutiness
grisliness1155143grisliness
gristliness1264003gristliness
grittiness1145163grittiness
guiltiness1144193guiltiness
gushiness13206853gushiness
gutsiness10226963gutsiness
heftiness1536313heftiness
hilliness1248923hilliness
hippiness1635463hippiness
histones11312803histone_s
huskiness16206583huskiness
iciness938863_i_ciness
ickiness1436753_ickiness
iffiness1435023_iffiness
inkiness1238693_inkiness
intines7921113_intine_s
isatines8310663_isatine_s
jettiness1675693jettiness
justness1535323just_ness
kinkiness1235763kinkiness
licitness1145373licitness
liminess10510643li_miness
lippiness1335413lippiness
listeners9147323listeners
listings93310043listin_gs
listless8269263list_less
liteness82213213li_teness
loftiness1236573loftiness
lostness837683lost_ness
manginess122010413manginess
manliness111310123manliness
marshiness1555063marshiness
martinets1138883martinets
mastixes1738253mastixe_s
mastless102610023mast_less
matinees102110423m_atinees
maziness19239543m_aziness
mealiness11310063mealiness
meetness1036653meet_ness
merriness1138293merriness
mestinoes1157313mestinoes
mestinos1048163mestin_os
midlines112613333midline_s
mildness1136523mi_ldness
milliners11289953milliners
millines102718063milline_s
miltiest103015173milti_est
mintiest103217143minti_est
minuteness1245293minuteness
mirthless1443353mirthless
misatones1148933misatone_s
misbiases1346253misbiases
misbinds1345163misbin_ds
miscites12313783miscite_s
miserliness1344913miserliness
misfiles133110983misfile_s
misfires132210583misfire_s
misgives14329293misgive_s
misguess1134643mis_guess
misinfers1445483mis_infers
misinters1138183mis_inters
mislies92922283misli_e_s
mislikers15317063mislikers
mislikes143311833mislike_s
mislives132912153mislive_s
missenses1148033missenses
missies93423983missi_e_s
missiles103015083missile_s
missioners1245853missioners
missises103513693missise_s
missives133212843missive_s
mistakers15117083mistakers
mistakes141213413mistake_s
mistends11419593misten_ds
misters93927513mist__ers
misthinks1843353misthin_ks
mistier93418713misti_e_r
mistime11312613mistime__
mistimed1339123mistime_d
misting103623383mistin__g
mistitles1147953mistitles
mistune9310653mistune__
mistuned1157723mistune_d
mistypes15116713mistype_s
mitiest93520053mi_ti_est
mitises9315543mi_tise_s
moisteners1244783moisteners
moldiness12227053moldiness
moodiness12197593moodiness
mooniness11157863mooniness
mootness1036753moot_ness
mopiness12259063m_opiness
mousiness11219023mousiness
muddiness1334763muddiness
mugginess1354633mugginess
murkiness15206293murkiness
mustiest103017533musti_est
mustinesses131010413mustinesses
muteness1039013m_uteness
mutines93117823m_utine_s
muzziness1933143muzziness
nattiness9239333nattiness
nippiness1334713nippiness
noisiness948343nois_iness
nosiness83211393nos_iness
nuttiness9207563nuttiness
oiliness8311563oi_liness
pastness102510503past_ness
peskiness15216523peskiness
pettiness1178703pettiness
pickiness1737623pickiness
pigginess1375453pigginess
pipiness1238003pi_piness
pithiness1437563pithiness
pitiless10127333pi_tiless
pixiness1736093pi_xiness
pottiness1179703pottiness
prissiness1266133prissiness
pushiness14197283pushiness
raspiness1137303raspiness
riminess10510093ri_miness
ritziness1835823ritziness
rootiness979063rootiness
rosiness82613173ros_iness
runtiness92410393runtiness
ruttiness9258793ruttiness
saltiness93312113saltiness
sassiness8249333sassiness
sestines82717243sestine_s
shiftiness1644793shiftiness
silkiness1337253silkiness
silliness9510363silliness
sissyness11252963sissyness
siziness1737423si_ziness
slatiness92511363slatiness
smuttiness1244403smuttiness
sootiness999833sootiness
tartiness92112053tartiness
tattiness9239413tattiness
thirstiness1442693thirstiness
tidiness938793ti_diness
tininess8310633ti_niness
tinniness936093tinniness
tipsiness1135703tipsiness
titaness836723ti_taness
trustiness1036653trustiness
vastness11257293vast_ness
vistaless1254573vistaless
washiness1537043washiness
waspiness1435793waspiness
wiliness1139113wi_liness
wimpiness1635293wimpiness
windiness1337373windiness
wintriness1345543wintriness
wiriness1138953wi_riness
wiseness112010753wis_eness
witness103010013wi_t_ness
yeastiness1344883yeastiness

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.423422437.4
2DLD Change Limit1486412436.92021479.9
3Display Results2432430.1102209.1
 (SQL Overall)1786912437.45323975.7
 
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.