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

146 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
daffiness163484(None) 
affines1339482_affine_s
daffiest1537842daffi_est
daffinesses1834842daffinesses
daftness1235532da_ftness
dailiness1038672dailiness
draftiness1444862draftiness
huffiness1844282huffiness
iffiness1435022_iffiness
miffiness1734522miffiness
puffiness1764362puffiness
achiness1339703_achiness
affine12310503_affine__
affined1436413_affine_d
affinely1743863_affinely
affixers2143293_affixers
affixes2035503_affixe_s
airiness8412213_airiness
artiness81615403_artiness
ashiness1138963_ashiness
baffies153612943baffi_e_s
bagginess1355953bagginess
balkiness1556903balkiness
balminess1356593balminess
bandiness122310243bandiness
battiness11239843battiness
bawdiness15235543bawdiness
beefiness1435583beefiness
caffeines1743913caffeine_s
caginess11310303ca_giness
cakiness1449553ca_kiness
campiness1537543campiness
canniness1138643canniness
cattiness112310633cattiness
comfiness1646953comfiness
craftiness1545753craftiness
daffier1457833daffi_e_r
daffing15369733daffin__g
dailyness1343643dailyness
daintiness1145963daintiness
dampness1336073da_mpness
dankness13256693da_nkness
darkness13247343da_rkness
datedness1187753datedness
dazedness20114963dazedness
deadliness12115893deadliness
deafness1236213deaf_ness
definers124211193d_efiners
defines114118683d_efine_s
deftness1236303d_eftness
dewiness1238453d_ewiness
dinginess1137823dinginess
dippiness1435973dippiness
dirtiness1039473dirtiness
ditsiness1048143ditsiness
ditziness1945883ditziness
dizziness1834183dizziness
dodginess1235283dodginess
dopiness11289973d_opiness
dorkiness14248053dorkiness
dottiness1058043dottiness
dowdiness1485693dowdiness
downiness13106713downiness
doziness18228553d_oziness
draffiest1644363draffi_est
dumpiness1435653dumpiness
duskiness14216683duskiness
dustiness102211033dustiness
dwarfness1642793dwarf_ness
earliness939693earliness
easiness8313043ea_siness
fanciness1437673fanciness
fattiness12239373fattiness
fluffiness1542603fluffiness
gabbiness1434403gabbiness
gaminess112911063ga_miness
gassiness10268313gassiness
gaudiness1136253gaudiness
gauziness1934613gauziness
gawkiness1734753gawkiness
goofiness1365603goofiness
hairiness1238013hairiness
halfness1435563half_ness
hamminess1635713hamminess
handiness132110933handiness
happiness1636003happiness
hardiness132310363hardiness
hastiness122410883hastiness
haziness20248513ha_ziness
heftiness1536313heftiness
jazziness2432843jazziness
kaffiyehs2581253kaffiyehs
laciness102112553la_ciness
lankiness1338053lankiness
larkiness1338113larkiness
laziness17239983la_ziness
leafiness1236483leafiness
loftiness1236573loftiness
maltiness112910573maltiness
manginess122010413manginess
manliness111310123manliness
massiness112810143massiness
matiness102114753ma_tiness
maziness19239543ma_ziness
nappiness1335233nappiness
nastiness92310573nastiness
nattiness9239333nattiness
niftiness1236363niftiness
pastiness112312353pastiness
pawkiness1835443pawkiness
raciness102413453ra_ciness
raffinose1542193raffinose
raffinoses1652083raffinoses
raffishness2043373raffishness
raininess949273raininess
randiness102511443randiness
ranginess101610213ranginess
raspiness1137303raspiness
safeness11239633sa_feness
saltiness93312113saltiness
sandiness102111713sandiness
sappiness1337443sappiness
sassiness8249333sassiness
sauciness1138043sauciness
savviness1534713savviness
sniffiness1643763sniffiness
spiffiness1842983spiffiness
stuffiness1643693stuffiness
tackiness1557693tackiness
taffies133012693taffi_e_s
talkiness1356913talkiness
tanginess10239283tanginess
tardiness10229923tardiness
tarriness9229243tarriness
tartiness92112053tartiness
tastiness92311143tastiness
tattiness9239413tattiness
tawniness1245123tawniness
wackiness1836523wackiness
waffies163611443waffi_e_s
wariness11313213wa_riness
washiness1537043washiness
waspiness1435793waspiness
waviness1437723wa_viness
waxiness1836723wa_xiness
zaniness1738663za_niness

Search took 10 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.420425454.8
2DLD Change Limit1486411468.98616541.4
3Display Results1461460.0632317.5
 (SQL Overall)1786911469.46918871.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.