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

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

112 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
fretfulness177622(None) 
artfulness1346402ar_tfulness
fatefulness1746012fatefulness
fitfulness1645732f_itfulness
forgetfulness2053742forgetfulness
fretfulnesses1945902fretfulnesses
fruitfulness1854882fruitfulness
restfulness1447232_restfulness
carefulness1645953care_fulness
dreadfulness1763883dreadfulness
dreamfulness1853593dreamfulness
eventfulness1854643eventfulness
faithfulness2154223faithfulness
fearfulness1745223fearfulness
forcefulness2054453forcefulness
fretless1138063fret__l_ess
frightfulness2363203frightfulness
gleefulness1554063gleefulness
gratefulness1655743gratefulness
hatefulness1745963hatefulness
heedfulness18104073heedfulness
hurtfulness1755013hurtfulness
lustfulness1445313lustfulness
needfulness1593993needfulness
regretfulness1753873regretfulness
ruefulness1346103_ruefulness
ruthfulness1754983_ruthfulness
tactfulness1645223tactfulness
tristfulness1564983tristfulness
trustfulness1565063trustfulness
truthfulness1864413truthfulness
usefulness1345723use_fulness
wistfulness1745273wistfulness
woefulness1645263woe_fulness
wrathfulness2154513wrathfulness
zestfulness2345313zestfulness
artfulnesses1546644ar_tfulnesses
awfulness1544414__awfulness
balefulness1645014balefulness
bashfulness1954224bashfulness
boastfulness1754414boastfulness
cheerfulness2053584cheerfulness
deceitfulness1963544deceitfulness
dolefulness1544884dolefulness
doubtfulness1853684doubtfulness
dutifulness1555084dutifulness
effortfulness18112414effortfulness
factualness1652994factualness
fancifulness2053754fancifulness
fatalness1245774f_at_alness
fatefulnesses1945994fatefulnesses
feetless1137384feet__l_ess
fellness1135914f_e__llness
fertileness1447574fertileness
fetidness1345444f_et_idness
fitfulnesses1866024f_itfulnesses
forgetfulnesses2262984forgetfulnesses
foulness11236654f___oulness
frailness1236544fr__ailness
freakiness1745184fre_akiness
freeness11710444fre___eness
freshness1545944fre__shness
fretful1346144fretful____
fretfully1844304fretful__ly
frothiness1645724frot_hiness
fruitfullest1862554fruitfullest
fruitfulnesses2094634fruitfulnesses
fulness10248964____fulness
gainfulness1544614gainfulness
gracefulness1855244gracefulness
harmfulness1984284harmfulness
helpfulness1953484helpfulness
hopefulness1954874hopefulness
joyfulness2343204_joyfulness
lawfulness1643854_lawfulness
manfulness1545644_manfulness
mercifulness1964414mercifulness
mindfulness1754064mindfulness
mirthfulness2053744mirthfulness
painfulness1645084painfulness
pitifulness1665484pitifulness
playfulness1953614playfulness
plentifulness1893284plentifulness
prayerfulness2162684prayerfulness
prettiness1257394pret_tiness
pridefulness1854324pridefulness
pushfulness1954144pushfulness
realness8410444_re__alness
regalness1045474_re_galness
resentfulness1664794resentfulness
restfullest1454134_restfullest
restfulnesses1646624_restfulnesses
retunes76918404_ret_u_ne_s
returnees9396114_ret_urnees
returners9376554_ret_urners
rightfulness1994894rightfulness
sinfulness1345844_sinfulness
slothfulness1853504slothfulness
songfulness1554584songfulness
soulfulness1444484soulfulness
spitefulness1754604spitefulness
sportfulness1754784sportfulness
tastefulness1554854tastefulness
tearfulness1445484tearfulness
tunefulness1455244tunefulness
unfruitfulness2062014unfruitfulness
wakefulness2154584wakefulness
wastefulness1854834wastefulness
willfulness1753514willfulness
wishfulness2054344wishfulness
wrongfulness1953254wrongfulness
youthfulness2153644youthfulness

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 Filter1786911488190.1561145455.1
2DLD Change Limit1488191128.54617413.9
3Display Results1121120.0631777.8
 (SQL Overall)1786911128.76520386.9
 
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.