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

113 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
miffiness173452(None) 
iffiness1435021_iffiness
daffiness1634842daffiness
huffiness1844282huffiness
miffiest1637142miffi_est
miffinesses1944362miffinesses
milkiness1536522milkiness
miriness10310462mi_riness
mistiness111911632mistiness
niftiness1236362niftiness
puffiness1764362puffiness
sniffiness1643762sniffiness
spiffiness1842982spiffiness
affines1339483_affine_s
airiness8412223ai_riness
beefiness1435583beefiness
biffies152710853biffi_e_s
biffins15358533biffin__s
bittiness11228333bittiness
comfiness1646953comfiness
dinginess1137823dinginess
dippiness1435973dippiness
dirtiness1039473dirtiness
ditsiness1048153ditsiness
ditziness1945883ditziness
dizziness1834183dizziness
fieriness1238633fieriness
filminess1435983filminess
fishiness1537343fishiness
fluffiness1542603fluffiness
giddiness1234693giddiness
goofiness1365603goofiness
heftiness1536313heftiness
hilliness1248923hilliness
hippiness1635463hippiness
iciness938863_i_ciness
ickiness1436753_ickiness
iffiest1337973_iffi_est
iffinesses1635583_iffinesses
inkiness1238693_inkiness
jiffies20327473jiffi_e_s
kinkiness1235763kinkiness
leafiness1236483leafiness
liminess10510643li_miness
lippiness1335413lippiness
loftiness1236573loftiness
maltiness112910573maltiness
manginess122010413manginess
manliness111310123manliness
massiness112810143massiness
matiness102114753m_atiness
maziness19239543m_aziness
mealiness11310063mealiness
meatiness11311183meatiness
merriness1138293merriness
messiness11248223messiness
midlines112613333midline_s
miffier1537023miffi_e_r
miffing16298403miffin__g
mightiness1645093mightiness
mildness1136523mi_ldness
milliners11289953milliners
millines102718063milline_s
misfiles133110983misfile_s
misfires132210583misfire_s
moldiness12227053moldiness
moodiness12197593moodiness
mooniness11157863mooniness
mopiness12259063m_opiness
mossiness11258323mossiness
mousiness11219033mousiness
muddiness1334763muddiness
muffineer1742013muffineer
muffineers1861563muffineers
muffins15308343muffin__s
mugginess1354633mugginess
murkiness15206293murkiness
mushiness14248223mushiness
muskiness15237443muskiness
mussiness11238303mussiness
mustiness112211663mustiness
muzziness1933143muzziness
nippiness1334713nippiness
oiliness8311563oi_liness
pickiness1737623pickiness
pigginess1375453pigginess
pipiness1238003pi_piness
pithiness1437563pithiness
pixiness1736093pi_xiness
rifeness1138593ri_feness
riminess10510103ri_miness
riskiness1336973riskiness
ritziness1835833ritziness
shiftiness1644793shiftiness
silkiness1337253silkiness
silliness9510363silliness
sissiness8217973sissiness
siziness1737423si_ziness
stiffness1543553stiff_ness
stuffiness1643693stuffiness
tidiness938793ti_diness
tiffined1543403tiffine_d
tiffins13327983tiffin__s
tininess8310633ti_niness
tinniness936093tinniness
tipsiness1135713tipsiness
wifeliness1644483wifeliness
wiliness1139113wi_liness
wimpiness1635293wimpiness
windiness1337373windiness
wiriness1138953wi_riness
wispiness1435633wispiness
wittiness12197223wittiness

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 Limit1486411137.36020195.8
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.82922824.2
 
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.