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

80 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
wonderfulnesses2262671wonderfulnesses_
wonderfulness2062873wonderfulne_s_s_
ponderousnesses1854614ponderousnesses_
woefulnesses1845344wo__e_fulnesses_
wondrousnesses1855844wond_rousnesses_
cheerfulnesses2253385_cheerfulnesses_
colorfulnesses1993835co_lorfulnesses_
dolefulnesses1774845do_le_fulnesses_
forcefulnesses2254175force_fulnesses_
forgetfulnesses2262985forgetfulnesses_
hopefulnesses2184595ho_pe_fulnesses_
masterfulnesses2053295masterfulnesses_
mindfulnesses1954435mind__fulnesses_
needfulnesses17134095__needfulnesses_
onerousnesses1348975_on_erousnesses_
prayerfulnesses2362405prayerfulnesses_
pridefulnesses2053895pride_fulnesses_
songfulnesses1754675son__gfulnesses_
tunefulnesses1655135tun_e_fulnesses_
vengefulnesses2153655venge_fulnesses_
voicefulnesses2253575voice_fulnesses_
wakefulnesses2354295w_ake_fulnesses_
wastefulnesses2054525waste_fulnesses_
wrongfulnesses2153175wron__gfulnesses_
balefulnesses1844856_bale_fulnesses_
boastfulnesses1954036bo_astfulnesses_
bountifulnesses2073196bountifulnesses_
carefulnesses1845696_care_fulnesses_
changefulnesses2462236change_fulnesses_
concertednesses2064216concertednesses_
dangerousnesses1754366dangerousnesses_
doubtfulnesses2053706do_ubtfulnesses_
fancifulnesses2254006fan_cifulnesses_
fatefulnesses1945996_fate_fulnesses_
fearfulnesses1945316__fearfulnesses_
fretfulnesses1945906__fretfulnesses_
generousnesses1556946gen_erousnesses_
gleefulnesses1764256__gleefulnesses_
gracefulnesses20154916grace_fulnesses_
gratefulnesses18135416grate_fulnesses_
guilefulnesses1853586guile_fulnesses_
hatefulnesses1945806_hate_fulnesses_
heedfulnesses20124106__heedfulnesses_
joyfulnesses2553506jo___yfulnesses_
manfulnesses1745836man___fulnesses_
moderatenesses1764406mo_deratenesses_
modernnesses1543866mo_der__nnesses_
monstrousnesses1654316monstrousnesses_
mournfulnesses1963426mo_urnfulnesses_
murderousnesses1853616murderousnesses_
odorousnesses1456736_o_dorousnesses_
orderlinesses1453396_order_linesses_
peacefulnesses2154706peace_fulnesses_
ponderousness16105336ponderousne_s_s_
regretfulnesses1963276regretfulnesses_
ruefulnesses1545936__rue_fulnesses_
shamefulnesses2253686shame_fulnesses_
sinfulnesses1546136sin___fulnesses_
sonorousnesses1356516son_orousnesses_
sorrowfulnesses2161966sorrowfulnesses_
soulfulnesses1654556so__ulfulnesses_
spitefulnesses1954416spite_fulnesses_
tastefulnesses1754606taste_fulnesses_
tearfulnesses1645536__tearfulnesses_
tendernesses1345076tender___nesses_
undutifulnesses1962676_undutifulnesses_
unlawfulnesses2052986_unlawfulnesses_
usefulnesses1545826__use_fulnesses_
watchfulnesses2552986w_atchfulnesses_
wearifulnesses2054656w_earifulnesses_
wildernesses1643626wilder___nesses_
willfulnesses1953886w__illfulnesses_
wishfulnesses2254286w__ishfulnesses_
wistfulnesses1955546w__istfulnesses_
woefulness1645266wo__e_fulne_s_s_
wondrousness1655306wond_rousne_s_s_
wontednesses1645996wonte___dnesses_
woodennesses1643656woode___nnesses_
wrathfulnesses2354376w_rathfulnesses_
youthfulnesses2353736yo_uthfulnesses_

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.326548131.9
2DLD Change Limit65874804.53314532.1
3Display Results80800.0601333.3
 (SQL Overall)178691804.91936326.7
 
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.