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

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

89 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
frightfulnesses256290(None) 
rightfulnesses2174461_rightfulnesses
frightfulness2363202frightfulne_s_s
faithfulnesses2354403faith_fulnesses
fitfulnesses1866023f_i__tfulnesses
forgetfulnesses2262983forgetfulnesses
fretfulnesses1945903fr__etfulnesses
fruitfulnesses2094633fr_uitfulnesses
rightfulness1994893_rightfulne_s_s
tristfulnesses1774333tri_stfulnesses
artfulnesses1546644ar___tfulnesses
brightnesses1844184bright___nesses
flightinesses2053134flight__inesses
mirthfulnesses2253634mirth_fulnesses
pridefulnesses2053894pri_defulnesses
regretfulnesses1963274_regretfulnesses
restfulnesses1646624_r_estfulnesses
righteousnesses1963394_righteousnesses
rightnesses1546234_right___nesses
ruthfulnesses1954944_ruth_fulnesses
sprightfulness2362204sprightfulne_s_s
trustfulnesses1764314tr_ustfulnesses
truthfulnesses2054114truth_fulnesses
wishfulnesses2254284_wish_fulnesses
wistfulnesses1955544_wi_stfulnesses
wrathfulnesses2354374wrath_fulnesses
bashfulnesses2154185_bash_fulnesses
blissfulnesses1852835bli_ssfulnesses
boastfulnesses1954035_boastfulnesses
deceitfulnesses2173045deceitfulnesses
delightfulness2261895delightfulne_s_s
doubtfulnesses2053705_doubtfulnesses
dreadfulnesses19193795dr_eadfulnesses
dreamfulnesses20183695dr_eamfulnesses
effortfulnesses20112185effortfulnesses
eventfulnesses2054275_eventfulnesses
faithfulness2154225faith_fulne_s_s
fancifulnesses2254005f_ancifulnesses
fatefulnesses1945995f__atefulnesses
fearfulnesses1945315f__earfulnesses
fitfulness1645735f_i__tfulne_s_s
forcefulnesses2254175f_orcefulnesses
forgetfulness2053745forgetfulne_s_s
fretfulness1776225fr__etfulne_s_s
frigidnesses1743645frig___idnesses
frivolousnesses2162845frivolousnesses
fruitfulness1854885fr_uitfulne_s_s
gainfulnesses17124615gai__nfulnesses
gracefulnesses20154915gr_acefulnesses
gratefulnesses18135415gr_atefulnesses
guilefulnesses1853585gui_lefulnesses
healthfulnesses2492905healthfulnesses
hurtfulnesses1954855__hurtfulnesses
knightlinesses2282445knight_linesses
lightfastnesses2261435_lightfastnesses
lightnesses1546145_light___nesses
lustfulnesses1655155__lustfulnesses
mightinesses1844385_might__inesses
mindfulnesses1954435_mi_ndfulnesses
painfulnesses18115145pai__nfulnesses
pitifulnesses1855575_pi_tifulnesses
prayerfulnesses2362405prayerfulnesses
pushfulnesses2153945_push_fulnesses
regardfulnesses2072525_regardfulnesses
resentfulnesses1883745resentfulnesses
rigorousnesses1565855_rigorousnesses
riotousnesses1357305_ri_otousnesses
ruefulnesses1545935_r__uefulnesses
sightlinesses1743865_sight_linesses
sinfulnesses1546135_si__nfulnesses
skillfulnesses2152655ski_llfulnesses
slightnesses1654625slight___nesses
slothfulnesses2053465sloth_fulnesses
songfulnesses1754675song__fulnesses
spitefulnesses1954415spi_tefulnesses
sportfulnesses1964175_sportfulnesses
sprightlinesses2161825spright_linesses
tactfulnesses1855265__tactfulnesses
tightnesses1565585_tight___nesses
tristfulness1564985tri_stfulne_s_s
uprightnesses19122785upright___nesses
vengefulnesses2153655veng_efulnesses
voicefulnesses2253575voi_cefulnesses
watchfulnesses2552985watch_fulnesses
weightinesses2052905weight__inesses
willfulnesses1953885_wi_llfulnesses
wrongfulnesses2153175wr_ongfulnesses
youthfulnesses2353735youth_fulnesses
zestfulnesses2555005__zestfulnesses

Search took 5 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.0961861364.6
2DLD Change Limit65874894.54614490.5
3Display Results89890.0601483.3
 (SQL Overall)178691894.70238003.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.