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

92 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
definitiveness216379(None) 
definiteness16105042definit__eness
defectiveness2256543def_ectiveness
defensiveness20115813defen_siveness
definitives1844213definitiv__e_s
derivativeness2163803derivativeness
diminutiveness2062673diminutiveness
deceptiveness2155694de_ceptiveness
decisiveness1855924de__cisiveness
decorativeness2054184decorativeness
definitenesses1864254definit__enesses
definitions1545604definiti_on__s
definitive1745084definitiv__e__
definitively2253254definitiv__ely
definitizes2444684definiti__ze_s
derisiveness1656964de__risiveness
descriptiveness2362274descriptiveness
distinctiveness2162914distinctiveness
divisiveness1954364d__ivisiveness
effectiveness2455674_effectiveness
fictiveness1946314__fi_ctiveness
finiteness1347114__finit__eness
fugitiveness1964024__fugitiveness
indefiniteness1863084indefinit__eness
infiniteness1555734infinit__eness
meditativeness2062884meditativeness
plaintiveness1854084plain_tiveness
primitiveness2054564_primitiveness
punitiveness1755364__punitiveness
reflectiveness2255104reflectiveness
refractiveness2254854refractiveness
repetitiveness1963844repetitiveness
resistiveness1656024resi_stiveness
retentiveness1657164reten_tiveness
sensitiveness1655814se_nsitiveness
acquisitiveness2971645acquisitiveness
attentiveness1665155atten_tiveness
daintiness1145965d_ain_ti__ness
defectivenesses2496075def_ectivenesses
defensivenesses2255785defen_sivenesses
definiens1345305defin__i_en__s
definition1445965definiti_on___
definitional1653035definiti_on_al
definitize2344675definiti__ze__
definitized2553815definiti__ze_d
definitizing2672995definitizin__g
definitudes1652535definit__ude_s
delusiveness1655755de__lusiveness
destituteness1462925de_stituteness
destructiveness2173805destructiveness
diffusiveness2353435dif_fusiveness
disruptiveness2083335disruptiveness
effusiveness2154935_ef_fusiveness
electiveness1757555_e_lectiveness
entireness1048365_e__n_tireness
evocativeness2154185_evocativeness
feminineness1773065femin__ineness
festiveness1748225__f_estiveness
furtiveness1746535__f_urtiveness
imaginativeness21152535imaginativeness
imitativeness1864735_imitativeness
incisiveness1756335___incisiveness
ineffectiveness2683005ineffectiveness
infinitives1744685infinitiv__e_s
initialness1155735___initialness
inquisitiveness2762665inquisitiveness
insensitiveness1863545insensitiveness
intuitiveness1656195_intuitiveness
inventiveness1956975inven_tiveness
nativeness1357835____nativeness
negativeness1656085ne__gativeness
offensiveness2274245offen_siveness
pensiveness1648655pe__n_siveness
perceptiveness2354785perceptiveness
perfectiveness2455345perfectiveness
positiveness1756495__positiveness
preventiveness2294895preven_tiveness
prohibitiveness2572265prohibitiveness
reactiveness1756925re__activeness
receptiveness2056125re_ceptiveness
reductiveness1955545re_ductiveness
reflexiveness2662745ref_lexiveness
respectiveness2155365respectiveness
restiveness1449665re___stiveness
restrictiveness2093415restrictiveness
secretiveness1865865se_cretiveness
seductiveness1955245se_ductiveness
selectiveness1856515se_lectiveness
tentativeness1655025te_ntativeness
transitiveness1763275transitiveness
vegetativeness2173255vegetativeness
vindictiveness2363035__vindictiveness

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.360496363.9
2DLD Change Limit95024927.09313396.9
3Display Results92920.0631460.3
 (SQL Overall)178691927.51623774.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.