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

83 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
profoundnesses206148(None) 
profoundness1851612profoundne_s_s
profanenesses1853463prof_anenesses
profusenesses18113863prof_usenesses
proudnesses1447483pr__ou_dnesses
rotundnesses1343823_ro_tundnesses
roundnesses1247043_r__oundnesses
boundnesses1446624___boundnesses
crookednesses2052604cro_okednesses
fondnesses1437704___fo_ndnesses
porousnesses1469274p_orou_snesses
profoundest1752924profound_e_s_t
pronenesses1379254pr__o_nenesses
rootednesses1345314_ro_otednesses
soundnesses1247524___soundnesses
unsoundnesses1453274_unsoundnesses
uprootednesses1752324upro_otednesses
amorousnesses1547795amorou_snesses
arduousnesses1456525arduou_snesses
artfulnesses1546645artf_u_lnesses
blondnesses1445545__blo_ndnesses
broadnesses1446185br__o_adnesses
brokennesses1843305bro_ken_nesses
broodinesses1544745bro_o_dinesses
brownnesses1664375br__own_nesses
crowdednesses2053175cro_wdednesses
fluidnesses1545475___fluidnesses
forlornnesses1652575forlorn_nesses
foulnesses1337925___fou_lnesses
frowardnesses20112895fro_wardnesses
frozennesses2443225fro_zen_nesses
goodnesses1236435_go_o__dnesses
grandnesses1348115gr___andnesses
groundmasses1651385gr__oundmasses
hoodednesses1744495_ho_odednesses
ironnesses1047825ir__o_n_nesses
joyousnesses2244665_joyou_snesses
looninesses1197995_lo_o_ninesses
loudnesses1138435___lou_dnesses
mooninesses13127945_mo_o_ninesses
odorousnesses1456725odorou_snesses
opportunenesses1961425opportunenesses
perilousnesses1667235perilou_snesses
perviousnesses1957245perviou_snesses
phoninesses1636455p__ho_ninesses
piousnesses1348955p__iou_snesses
piteousnesses1557165piteou_snesses
pointednesses1654955p_ointednesses
pompousnesses1955455pompou_snesses
poornesses1236805p_o_o__rnesses
preciousnesses1857515preciou_snesses
preparednesses1963065preparednesses
presentnesses1554405pr_esentnesses
previousnesses1966455previou_snesses
procuresses1543815pro_cu__resses
profaneness1653585prof_anene_s_s
professes1437875prof_____esses
profounder1643325profound____er
profounds1543935profound_____s
profundities1852625prof_und_ities
profuseness1653035prof_usene_s_s
prolificnesses2151165prolificnesses
promotivenesses22113885promotivenesses
promptnesses1843615pr__omptnesses
propernesses1645005pr__opernesses
propounders1643265propound_e__rs
prosinesses13310855pr__o_sinesses
proudness1246695pr__ou_dne_s_s
provablenesses2154855provablenesses
puninesses121110755p____uninesses
purblindnesses1951145purblindnesses
riotousnesses1357305riotou_snesses
robustnesses1443785_ro_bustnesses
roominesses1337425_ro_o_minesses
rootinesses1139515_ro_o_tinesses
rottennesses1244415_rotten_nesses
rotundness1143405_ro_tundne_s_s
roughnesses15105135_r__oughnesses
roundednesses1554285_roundednesses
roundness1047015_r__oundne_s_s
thoroughnesses2171875thoroughnesses
wrongnesses1544925wr__o_ngnesses
youngnesses1544285___youngnesses

Search took 7 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 Filter178691950240.1231452772.4
2DLD Change Limit95024836.53314545.2
3Display Results83830.0461804.3
 (SQL Overall)178691836.70226662.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.