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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
prayerfulnesses2362401prayerfulnesses_
prayerfulness2162683prayerfulne_s_s_
gracefulnesses20154914grace_fulnesses_
gratefulnesses18135414grate_fulnesses_
peacefulnesses2154704peace_fulnesses_
playfulnesses2153644play__fulnesses_
pridefulnesses2053894pride_fulnesses_
balefulnesses1844855_bale_fulnesses_
carefulnesses1845695_care_fulnesses_
cheerfulnesses2253385_cheerfulnesses_
fatefulnesses1945995_fate_fulnesses_
fearfulnesses1945315fea__rfulnesses_
fretfulnesses1945905fr__etfulnesses_
hatefulnesses1945805_hate_fulnesses_
masterfulnesses2053295masterfulnesses_
painfulnesses18115145p_a_infulnesses_
ruefulnesses1545935_r_ue_fulnesses_
shamefulnesses2253685shame_fulnesses_
tearfulnesses1645535tea__rfulnesses_
wakefulnesses2354295_wake_fulnesses_
wonderfulnesses2262675wonderfulnesses_
wrathfulnesses2354375wra_thfulnesses_
artfulnesses1546646__a_rtfulnesses_
awfulnesses1744946__a__wfulnesses_
bashfulnesses2154186_ba_shfulnesses_
beautifulnesses2083456beautifulnesses_
boastfulnesses1954036boa_stfulnesses_
changefulnesses2462236changefulnesses_
colorfulnesses1993836_colorfulnesses_
dolefulnesses1774846_dole_fulnesses_
dreadfulnesses19193796dr_eadfulnesses_
dreamfulnesses20183696dr_eamfulnesses_
faithfulnesses2354406_faithfulnesses_
fancifulnesses2254006_fancifulnesses_
forcefulnesses2254176force_fulnesses_
forgetfulnesses2262986forgetfulnesses_
frightfulnesses2562906frightfulnesses_
fruitfulnesses2094636fr_uitfulnesses_
gainfulnesses17124616_ga_infulnesses_
gleefulnesses1764256__gleefulnesses_
gracefulness1855246grace_fulne_s_s_
gratefulness1655746grate_fulne_s_s_
guilefulnesses1853586guile_fulnesses_
harmfulnesses2164306_ha_rmfulnesses_
healthfulnesses2492906healthfulnesses_
heedfulnesses20124106__heedfulnesses_
hopefulnesses2184596_hope_fulnesses_
joyfulnesses2553506_joy__fulnesses_
lawfulnesses1844146_la__wfulnesses_
manfulnesses1745836_ma__nfulnesses_
materialnesses1653916_materialnesses_
needfulnesses17134096__needfulnesses_
paperinesses1646056p_aper__inesses_
peacefulness1954986peace_fulne_s_s_
pitifulnesses1855576p__itifulnesses_
playfulness1953616play__fulne_s_s_
plentifulnesses2093176plentifulnesses_
ponderousnesses1854616ponderousnesses_
practicalnesses2162956practicalnesses_
pridefulness1854326pride_fulne_s_s_
propernesses1645016proper___nesses_
pushfulnesses2153946p__ushfulnesses_
ravenousnesses1795036_ravenousnesses_
regardfulnesses2072526_regardfulnesses_
regretfulnesses1963276regretfulnesses_
resentfulnesses1883746_resentfulnesses_
restfulnesses1646626_r_estfulnesses_
rightfulnesses2174466_rightfulnesses_
ruthfulnesses1954946_r_uthfulnesses_
spitefulnesses1954416spite_fulnesses_
tactfulnesses1855266_ta_ctfulnesses_
tastefulnesses1754606_tastefulnesses_
thankfulnesses2453096tha_nkfulnesses_
tristfulnesses1774336tr_istfulnesses_
trustfulnesses1764316tr_ustfulnesses_
truthfulnesses2054116tr_uthfulnesses_
tunefulnesses1655136_tune_fulnesses_
usefulnesses1545826__use_fulnesses_
vengefulnesses2153656venge_fulnesses_
voicefulnesses2253576voice_fulnesses_
wastefulnesses2054526_wastefulnesses_
watchfulnesses2552986_watchfulnesses_
wearifulnesses2054656wea_rifulnesses_
woefulnesses1845346__woe_fulnesses_
wrongfulnesses2153176wr_ongfulnesses_

Search took 6 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 Filter178691658740.0931921408.6
2DLD Change Limit65874854.92313380.9
3Display Results85850.0631349.2
 (SQL Overall)178691855.07935182.3
 
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.