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

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
sportiveness176698(None) 
abortiveness1755322abortiveness
sportiness1278232sporti__ness
sportivenesses1956282sportivenesses
supportiveness2162672supportiveness
assertiveness1655503assertiveness
costiveness1648213_costiveness
forgiveness1864983_forgiveness
furtiveness1746533_furtiveness
operativeness1876663operativeness
positiveness1756493_positiveness
secretiveness1865863secretiveness
sportfulness1754783sportfulness
sportinesses1447873sportinesses
spottiness1285763spotti__ness
votiveness1646353_vo_tiveness
abortivenesses1985294abortivenesses
activeness1547704__activeness
adaptiveness1853644adaptiveness
amativeness1646224_amativeness
aversiveness1896234aversiveness
coerciveness1955404coerciveness
creativeness1747764creativeness
cursiveness1647074_cursiveness
decorativeness2054184decorativeness
dispersiveness20104054dispersiveness
electiveness1757554electiveness
erosiveness1447574ero_siveness
evocativeness2154184evocativeness
fertileness1447574_fertileness
festiveness1748224_festiveness
fictiveness1946314_fictiveness
fugitiveness1964024fugitiveness
imperativeness2155474imperativeness
lucrativeness1854574lucrativeness
motiveless1542964_mo_tiveless
nativeness1357834__nativeness
negativeness1656084negativeness
normativeness1855004_normativeness
opportuneness17111804opportuneness
passiveness1646264_passiveness
pensiveness1648654_pensiveness
petiteness1248494_p_etiteness
politeness1247984_po_liteness
porkiness15249194_porki__ness
porteress1137934_port__eress
portieres1138214_porti_ere_s
portioners1257414_porti_oners
portionless1344024_portionless
portliness1246834_port_liness
pottiness1179704_potti__ness
primeness1338654_p_r_imeness
promotiveness2053924promotiveness
punitiveness1755364punitiveness
reactiveness1756924reactiveness
respectiveness2155364respectiveness
responsiveness1963194responsiveness
restiveness1449664_restiveness
scriveners1543144s_cr_iveners
seductiveness1955244seductiveness
selectiveness1856514selectiveness
sensitiveness1655814sensitiveness
servileness1445924s_ervileness
shorteners1345084short__eners
shortness1236734short___ness
snootiness1085834snooti__ness
snottiness1055594snotti__ness
sootiness999834s_ooti__ness
sordidness1244634s_ordi_dness
soreness8914794s_or___eness
sorriness939584s_orri__ness
sortileges1152744s_ortilege_s
sottishness1444434s_ottishness
spareness1139864spar___eness
sparseness1245494spar__seness
spiritedness1553784spiritedness
sponginess1344594spongi__ness
spookiness1644434spooki__ness
sporogeneses1554854spor_ogeneses
sporogenesis1554314spor_ogenesis
sportiest111711024sporti___est
sportive1348334sportiv__e__
sportively1845024sportiv__ely
spottinesses1445684spottinesses
spruceness1444104sp_r_uceness
storminess1245214stormi__ness
suasiveness1446434s_uasiveness
subtileness1345404s_ubtileness
superlativeness20283944superlativeness

Search took 9 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 Filter1786911247900.1401276364.3
2DLD Change Limit124790897.83015937.4
3Display Results89890.0601483.3
 (SQL Overall)178691898.03022252.9
 
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.