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

68 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
practicalnesses2162951practicalnesses_
practicalness1953323practicalne_s_s_
criticalnesses1853154cr_iticalnesses_
poeticalnesses1853104p_oeticalnesses_
radicalnesses16124144_ra_dicalnesses_
factualnesses1853695_fact_ualnesses_
fanaticalnesses2082315fanaticalnesses_
fractiousnesses2075875fractiousnesses_
franticnesses1843675frantic__nesses_
identicalnesses1882425identicalnesses_
ironicalnesses1662585ir_onicalnesses_
palatialnesses1653385palati_alnesses_
pastoralnesses1653135p_astoralnesses_
physicalnesses2461945p_hysicalnesses_
practicableness2362705practicable_ness
practicalities2053565practical_ities_
rationalnesses1452635_ra_tionalnesses_
verticalnesses1953675_verticalnesses_
activenesses1758216__acti_venesses_
beautifulnesses2083456beautifulnesses_
brackishnesses2552646bracki_shnesses_
brattinesses1466266bratti___nesses_
craftinesses1746386crafti___nesses_
criticalness1653506cr_iticalne_s_s_
draftinesses1645756drafti___nesses_
ethicalnesses1853206__ethicalnesses_
exactingnesses2452666exacti_ngnesses_
factiousnesses1977516_factiousnesses_
fatalnesses1456286_fa_t__alnesses_
finicalnesses1853836__finicalnesses_
frailnesses1447596fra__i__lnesses_
gracefulnesses20154916grac_efulnesses_
gracilenesses1655166grac_i_lenesses_
graciousnesses1757726grac_iousnesses_
gradualnesses1552886gra__dualnesses_
graphicnesses2151846graphic__nesses_
gratefulnesses18135416gra_tefulnesses_
habitualnesses1962216_habitualnesses_
illogicalnesses1871666illogicalnesses_
initialnesses1395616_initi_alnesses_
logicalnesses1653196__logicalnesses_
lyricalnesses1853106__lyricalnesses_
naturalnesses1354256_na_turalnesses_
pastinesses13911716p_asti___nesses_
patchinesses1944366p_a_t_chinesses_
peacefulnesses2154706peac_efulnesses_
pictorialnesses1962146p_ictorialnesses_
pitifulnesses1855576p__itifulnesses_
placidnesses1743956plac_i__dnesses_
plentifulnesses2093176plentifulnesses_
poeticalness1653456p_oeticalne_s_s_
practicals1645546practical_____s_
prankishnesses2353206pranki_shnesses_
prayerfulnesses2362406prayerfulnesses_
preachinesses2043756preachi___nesses_
preciousnesses1857536prec_iousnesses_
precisenesses1756286prec_i_senesses_
prettinesses1447546pretti___nesses_
pricklinesses2143626pr___icklinesses_
racinesses12313516_rac_i___nesses_
radicalness1454586_ra_dicalne_s_s_
reactivenesses1956926reacti_venesses_
specialnesses1753866spec_i_alnesses_
tactfulnesses1855266_tact_fulnesses_
tractablenesses1964056tractablenesses_
typicalnesses2062546__typicalnesses_
whimsicalnesses2561336whimsicalnesses_
wrathfulnesses2354376wra_thfulnesses_

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.310576422.6
2DLD Change Limit65874685.04613054.7
3Display Results68680.0501360.0
 (SQL Overall)178691685.40633054.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.