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

100 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
derivativeness216380(None) 
decorativeness2054183decorativeness
definitiveness2163793definitiveness
derisiveness1656963deri__siveness
derivatives1844643derivativ__e_s
meditativeness2062883meditativeness
pervasiveness2155133per_vasiveness
creativeness1747764_cr_eativeness
deceptiveness2155694de_ceptiveness
decisiveness1855924deci__siveness
defectiveness2256544de_fectiveness
derivations15611494derivati_on__s
derivative1746684derivativ__e__
derivatively2264314derivativ__ely
derivatizes2445154derivati__ze_s
descriptiveness2362274descri_ptiveness
diminutiveness2062674diminutiveness
divisiveness1954364d__ivisiveness
evasiveness1755744_e__vasiveness
evocativeness2154184_evocativeness
imitativeness1864734_imitativeness
innovativeness2063174innovativeness
negativeness1656084ne__gativeness
normativeness1855004nor_mativeness
operativeness1876664oper__ativeness
perceptiveness2354784perceptiveness
perfectiveness2455344perfectiveness
persuasiveness1963464persuasiveness
primitiveness2054564_primitiveness
privateness1655714_privat__eness
resistiveness1656024resi_stiveness
tentativeness1655024te_ntativeness
vegetativeness2173254vegetativeness
versatileness1654014ver_satileness
abrasiveness1754935abr__asiveness
alternativeness1862615alter_nativeness
amativeness1646225___amativeness
combativeness2254175_combativeness
cumulativeness2162715cumulativeness
defensiveness20115815de_fensiveness
definiteness16105045defi__niteness
delusiveness1655755de__lusiveness
deprivations1897925deprivati_on__s
derisivenesses1857235deri__sivenesses
derivates13310095derivat____e_s
derivation14712785derivati_on___
derivational1654265derivati_on_al
derivatize2345985derivati__ze__
derivatized2554515derivati__ze_d
derivatizing2654825derivatizin__g
desirableness1666955desira_bleness
desolateness1354595desolat__eness
destructiveness2173805destructiveness
disruptiveness2083335disruptiveness
dissuasiveness17112645dissuasiveness
distinctiveness2162915distinctiveness
effectiveness2455675_effectiveness
electiveness1757565_e_lectiveness
erosiveness1447585_er__osiveness
fertileness1447585fer___tileness
festiveness1748225fe___stiveness
fictiveness1946315__fi_ctiveness
figurativeness2162625figurativeness
fugitiveness1964025fugi__tiveness
furtiveness1746535fur___tiveness
imaginativeness21152535imaginativeness
imperativeness2155475imperativeness
implicativeness2462505implicativeness
invasiveness1855715__invasiveness
lucrativeness1854575_lucrativeness
nativeness1357835____nativeness
percussiveness2193735percussiveness
permissiveness2163185permissiveness
pervasivenesses2355205per_vasivenesses
plaintiveness1854095plai_ntiveness
positiveness1756495posi__tiveness
preventiveness2294895preventiveness
privatives18186475_privativ__e_s
promotiveness2053925_promotiveness
provocativeness25132195_provocativeness
punitiveness1755365puni__tiveness
reactiveness1756925__reactiveness
receptiveness2056125re_ceptiveness
reductiveness1955545re_ductiveness
reflectiveness2255105reflectiveness
refractiveness2254855refractiveness
repetitiveness1963845repetitiveness
respectiveness2155365respectiveness
restiveness1449665__r_estiveness
restrictiveness2093415restri_ctiveness
retentiveness1657165re_tentiveness
secretiveness1865865se_cretiveness
seductiveness1955245se_ductiveness
selectiveness1856515se_lectiveness
sensitiveness1655815se_nsitiveness
servileness1445935ser_v__ileness
superlativeness20283945super_lativeness
talkativeness2053005_talkativeness
veritableness1856515verita_bleness
votiveness1646355____votiveness

Search took 8 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.390458182.1
2DLD Change Limit950241006.86013851.9
3Display Results1001000.0631587.3
 (SQL Overall)1786911007.31324434.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.