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

165 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
iffiness143502(None) 
miffiness1734521miffiness
affines1339482affine_s
daffiness1634842daffiness
huffiness1844282huffiness
iciness938862i_ciness
ickiness1436752ickiness
iffiest1337952iffi_est
iffinesses1635582iffinesses
inkiness1238692inkiness
niftiness1236362niftiness
puffiness1764362puffiness
sniffiness1643752sniffiness
spiffiness1842982spiffiness
achiness1339703achiness
affine12310503affine__
affined1436413affine_d
affinely1743863affinely
affixers2143293affixers
affixes2035503affixe_s
airiness8412213airiness
artiness81615403artiness
ashiness1138963ashiness
beefiness1435583beefiness
biffies152710853biffi_e_s
biffins15358533biffin__s
bittiness11228333bittiness
boniness102211803boniness
boxiness17247813boxiness
business102110693business
caginess11310303caginess
cakiness1449553cakiness
comfiness1646953comfiness
cosiness103214283cosiness
coziness19319823coziness
daftness1235533daftness
definers124211193definers
defines114118683define_s
deftness1236303deftness
dewiness1238453dewiness
dinginess1137823dinginess
dippiness1435973dippiness
dirtiness1039473dirtiness
ditsiness1048143ditsiness
ditziness1945883ditziness
dizziness1834183dizziness
dopiness11289973dopiness
doziness18228553doziness
easiness8313043easiness
edginess1036053edginess
eeriness8311873eeriness
fainest10417703_fainest
fairness1136563_fairness
farness102912203_farness
fatness103311293_fatness
fewness1335003_fewness
feyness1334923_feyness
fieriness1238623fieriness
filminess1435983filminess
fineness11310643fineness
fines86644263__fine_s
finesse10187643__finesse
finest94321733__finest
finless102810783__finless
firmness1334743firmness
fishiness1537343fishiness
fitness10299393_fitness
fluffiness1542603fluffiness
foxiness18257403foxiness
foziness20257803foziness
fulness10248963_fulness
gaminess112911053gaminess
giddiness1234683giddiness
gluiness937363gluiness
goofiness1365603goofiness
goriness9310753goriness
haziness20248513haziness
heftiness1536313heftiness
hilliness1248923hilliness
hippiness1635463hippiness
hokiness152510183hokiness
holiness112512503holiness
hominess132712453hominess
idleness936843idleness
iffier1236763iffi_e_r
illness736473i_llness
imines84918353i_mine_s
infidels1244123infidels
infixes17238133infixe_s
intines7921113intine_s
iodines83616633iodine_s
ironness836953ironness
itchiness1444753itchiness
jiffies20327473jiffi_e_s
jokiness19227393jokiness
kinkiness1235763kinkiness
laciness102112553laciness
laziness17239983laziness
leafiness1236483leafiness
liminess10510643liminess
lippiness1335413lippiness
loftiness1236573loftiness
loginess9310163loginess
matiness102114743matiness
maziness19239543maziness
miffiest1637123miffi_est
miffinesses1944363miffinesses
milkiness1536523milkiness
miriness10310463miriness
mistiness111911633mistiness
mopiness12259063mopiness
nippiness1334713nippiness
nosiness83211393nosiness
offenses1443833offenses
officers1643803officers
offices1536243office_s
offings14285833offin_gs
offishness1943793offishness
oiliness8311563oiliness
ooziness17237513ooziness
pickiness1737623pickiness
pigginess1375453pigginess
pipiness1238003pipiness
pithiness1437563pithiness
pixiness1736093pixiness
pokiness14219863pokiness
puniness101610273puniness
raciness102413453raciness
refiners114713313refiners
refines105426343refine_s
rifeness1138583rifeness
riminess10510093riminess
riskiness1336963riskiness
ritziness1835823ritziness
ropiness102311073ropiness
rosiness82613173rosiness
safeness11239633safeness
sexiness1537943sexiness
shiftiness1644793shiftiness
silkiness1337253silkiness
silliness9510363silliness
sissiness8217963sissiness
siziness1737423siziness
softness1136433softness
stiffness1543553stiff_ness
stuffiness1643683stuffiness
tidiness938793tidiness
tiffined1543403tiffine_d
tiffins13327983tiffin__s
tininess8310633tininess
tinniness936093tinniness
tipsiness1135703tipsiness
ugliness936863ugliness
unfitness1244843unfitness
wariness11313213wariness
waviness1437723waviness
waxiness1836723waxiness
wifeliness1644483wifeliness
wiliness1139113wiliness
wimpiness1635293wimpiness
windiness1337373windiness
wiriness1138953wiriness
wispiness1435633wispiness
wittiness12197223wittiness
zaniness1738663zaniness

Search took 9 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 Limit1461621657.86018595.7
3Display Results1651650.0762171.1
 (SQL Overall)1786911658.09222082.4
 
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.