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 “fancifulnesses” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

190 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
fancifulnesses225400(None) 
fancifulness2053752fancifulne_s_s
faithfulnesses2354403faithfulnesses
fancinesses1638143fanci___nesses
fatefulnesses1945993fa_tefulnesses
forcefulnesses2254173forcefulnesses
manfulnesses1745833man__fulnesses
mercifulnesses2154273mercifulnesses
tactfulnesses1855263ta_ctfulnesses
watchfulnesses2552983watchfulnesses
ancientnesses1553284_ancientnesses
anxiousnesses2057694_anxiousnesses
artfulnesses1546644_a_rtfulnesses
awfulnesses1744944_a__wfulnesses
balefulnesses1844854ba_lefulnesses
bashfulnesses2154184ba_shfulnesses
beautifulnesses2083454beautifulnesses
bountifulnesses2073194bountifulnesses
carefulnesses1845694ca_refulnesses
changefulnesses2462234changefulnesses
dutifulnesses1755114_dutifulnesses
facilenesses1756724fa_ci_lenesses
factiousnesses1977514factiousnesses
factualnesses1853694fa_ctualnesses
fanaticalnesses2082314fanaticalnesses
fearfulnesses1945314f_earfulnesses
finicalnesses1853834fin_icalnesses
fitfulnesses1866024f__itfulnesses
fretfulnesses1945904f_retfulnesses
fruitfulnesses2094634fruitfulnesses
gainfulnesses17124614ga_infulnesses
gracefulnesses20154914gracefulnesses
harmfulnesses2164304ha_rmfulnesses
hatefulnesses1945804ha_tefulnesses
lawfulnesses1844144la__wfulnesses
manifoldnesses2061444man_ifoldnesses
mindfulnesses1954434min_dfulnesses
painfulnesses18115144pa_infulnesses
peacefulnesses2154704peacefulnesses
pitifulnesses1855574_pitifulnesses
plentifulnesses2093174plentifulnesses
rancidnesses1544884ranci__dnesses
sinfulnesses1546134sin__fulnesses
songfulnesses1754674son_gfulnesses
tastefulnesses1754604tastefulnesses
thankfulnesses2453094than_kfulnesses
tunefulnesses1655134tun_efulnesses
vengefulnesses2153654vengefulnesses
voicefulnesses2253574voicefulnesses
wakefulnesses2354294wa_kefulnesses
wastefulnesses2054524wastefulnesses
wearifulnesses2054654wearifulnesses
acidnesses1337255_a_ci__dnesses
bandinesses14109735bandi___nesses
blissfulnesses1852835blissfulnesses
boastfulnesses1954035boastfulnesses
candidnesses1685395candi__dnesses
canninesses1368855canni___nesses
canorousnesses16127065canorousnesses
capaciousnesses2195465capaciousnesses
captiousnesses1886935captiousnesses
cautiousnesses1687615cautiousnesses
chancinesses1945035chanci___nesses
cheerfulnesses2253385cheerfulnesses
civilnesses1644855___civilnesses
colorfulnesses1993835colorfulnesses
concisenesses1746595conci_senesses
consciousnesses1855815consciousnesses
deceitfulnesses2173045deceitfulnesses
dolefulnesses1774845_dolefulnesses
doubtfulnesses2053705doubtfulnesses
dreadfulnesses19193795dreadfulnesses
dreamfulnesses20183695dreamfulnesses
effortfulnesses20112185effortfulnesses
enviousnesses1647885_enviousnesses
eventfulnesses2054275eventfulnesses
fabulousnesses1954705fabulousnesses
facetiousnesses2055325facetiousnesses
faddishnesses2143245faddi_shnesses
faintishnesses2053305fainti_shnesses
faintnesses1447145fa__i_ntnesses
fairnesses1357385fa__i__rnesses
faithfulness2154225faithfulne_s_s
famousnesses1745715fa__mousnesses
fanciless1444605fanci__l_e_s_s
fanciness1437675fanci___ne_s_s
fatalnesses1456285fa___talnesses
fatefulness1746015fa_tefulne_s_s
fattinesses14118975fatti___nesses
fatuousnesses1686865fa_tuousnesses
ferociousnesses2055845ferociousnesses
finickinesses2272065fin_ickinesses
finitenesses1557725fin_i_tenesses
forcefulness2054455forcefulne_s_s
forciblenesses2154195forciblenesses
forgetfulnesses2262985forgetfulnesses
foulnesses1337935f____oulnesses
fractiousnesses2075875fractiousnesses
frailnesses1447595f_rai__lnesses
franticnesses1843675franti__cnesses
frightfulnesses2562905frightfulnesses
fulnesses1239055_____fulnesses
funkinesses18137005funki___nesses
funninesses14106875funni___nesses
gleefulnesses1764255_gleefulnesses
graciousnesses1757725graciousnesses
gratefulnesses18135415gratefulnesses
guilefulnesses1853585guilefulnesses
habitualnesses1962215ha_bitualnesses
handinesses151410275handi___nesses
healthfulnesses2492905healthfulnesses
heedfulnesses20124105_heedfulnesses
helpfulnesses2153545_helpfulnesses
hopefulnesses2184595_hopefulnesses
hurtfulnesses1954855_hurtfulnesses
joyfulnesses2553505__joyfulnesses
lacinesses12312125la_ci___nesses
lankinesses1539015lanki___nesses
lusciousnesses1556245lusciousnesses
lustfulnesses1655155_lustfulnesses
maliciousnesses19195985maliciousnesses
manfulness1545645man__fulne_s_s
manginesses1499595mangi___nesses
manlinesses13910195manli___nesses
mannishnesses1873965manni_shnesses
masterfulnesses2053295masterfulnesses
mercifulness1964415mercifulne_s_s
mirthfulnesses2253645mirthfulnesses
mournfulnesses1963425mournfulnesses
needfulnesses17134095_needfulnesses
niftinesses1437245__n_iftinesses
officiousnesses2364295officiousnesses
playfulnesses2153645_playfulnesses
prayerfulnesses2362405prayerfulnesses
preciousnesses1857535preciousnesses
pridefulnesses2053895pridefulnesses
pushfulnesses2153945_pushfulnesses
racinesses12313515ra_ci___nesses
radicalnesses16124145ra_dicalnesses
randinesses121311205randi___nesses
ranginesses121210115rangi___nesses
rapaciousnesses19105475rapaciousnesses
raucousnesses1556565rauc_ousnesses
restfulnesses1646625_restfulnesses
rightfulnesses2174465rightfulnesses
ruefulnesses1545935__ruefulnesses
ruthfulnesses1954945_ruthfulnesses
sagaciousnesses1765245sagaciousnesses
salaciousnesses1665605salaciousnesses
sandinesses12911395sandi___nesses
saucinesses1338985sauci___nesses
scornfulnesses1953205scornfulnesses
shamefulnesses2253685shamefulnesses
skillfulnesses2152655skillfulnesses
slothfulnesses2053465slothfulnesses
sniffinesses1843695_sn_iffinesses
soulfulnesses1654555_soulfulnesses
spaciousnesses17147185spaciousnesses
specialnesses1753865speci_alnesses
speciousnesses17146905speciousnesses
spitefulnesses1954415spitefulnesses
sportfulnesses1964175sportfulnesses
tacitnesses1336325ta_ci__tnesses
tactfulness1645225ta_ctfulne_s_s
tangiblenesses1753595tangiblenesses
tanginesses1278885tangi___nesses
tearfulnesses1645535_tearfulnesses
tenaciousnesses1756075tenaciousnesses
tristfulnesses1774335tristfulnesses
trustfulnesses1764315trustfulnesses
truthfulnesses2054115truthfulnesses
undutifulnesses1962675undutifulnesses
uniquenesses2154715_un_iquenesses
unlawfulnesses2052985unlawfulnesses
usefulnesses1545825__usefulnesses
vacuousnesses1896515va_cuousnesses
variousnesses1648675va_riousnesses
venialnesses1555705ven_i_alnesses
viciousnesses1848055_viciousnesses
watchfulness2353085watchfulne_s_s
willfulnesses1953885_willfulnesses
wishfulnesses2254285_wishfulnesses
wistfulnesses1955545_wistfulnesses
woefulnesses1845345__woefulnesses
wonderfulnesses2262675wonderfulnesses
wrathfulnesses2354375wrathfulnesses
wrongfulnesses2153175wrongfulnesses
youthfulnesses2353735youthfulnesses
zaninesses19310385zan_i___nesses
zestfulnesses2555005_zestfulnesses

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 Filter178691950240.360496363.9
2DLD Change Limit950241906.65614276.4
3Display Results1901900.1401357.1
 (SQL Overall)1786911907.15624970.8
 
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.