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

82 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
duplicative195417(None) 
applicative2074712applicative
duplicate1447002duplicat__e
duplicating1745402duplicating
duplication1647292duplication
explicative2554452explicative
implicative2054662implicative
reduplicative2172832reduplicative
replicative1846082replicative
duplicated1655833duplicat_ed
duplicates1546633duplicat_es
duplications1746283duplications
duplicator1544803duplicat_or
duplicators1644293duplicators
duplicities1645333duplicities
lubricative1853453lubricative
placative1646223__placative
qualitative2353193qualitative
adjudicative2661964adjudicative
afflictive21102804afflic_tive
affricative2253034affricative
application1747474application
applicatively2562544applicatively
colligative1754344colligative
declarative1754314declarative
deflective1956094deflec_tive
delicate11315494d_elicat__e
delineative1554664d_elineative
depletive1545624depl__etive
depreciative2084084depreciative
derivative1746684d_erivative
desiccative1953944desiccative
deviative1647724d_evi_ative
dilative1239524d___ilative
dissipative1753814dissipative
dominative1677394d_ominative
duplicitous1672004duplicitous
duplicity1744664duplic__ity
durative1239074du___rative
educative15136554edu___cative
explanative2353104explanative
explicate20117494explicat__e
explicating2356124explicating
explication2248454explication
explicatively30102564explicatively
exploitative2452594exploitative
explorative2354244explorative
fricative1746744__fricative
implicate1547274implicat__e
implicating1855744implicating
implication1747774implication
implicatively2552864implicatively
indicative1647714_indicative
inflictive18104634inflic_tive
ligative1258804___ligative
locative1338684___locative
multiplicative2381934multiplicative
palliative1544774palli_ative
plicate11314514__plicat__e
plication13311684__plication
plicature1344024__plicature
precative16312574__precative
predicative1947374predicative
privative17188294__privative
publication1746574publication
pulsative1455174pu_l_sative
reduplicate1654044reduplicat__e
reduplicating1953504reduplicating
reduplication1855044reduplication
reduplicatively2671474reduplicatively
replicate13410044replicat__e
replicating1649094replicating
replication15712014replication
ruminative1546434ru_minative
suffocative2252344suffocative
superlative1648254superlative
supplicate1644524supplicat__e
supplicating1953744supplicating
supplication1855394supplication
suppurative1853384suppurative
urinative1247654_u_rinative
vindicative2053794vindicative

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819829.03016480.5
3Display Results82820.0461782.6
 (SQL Overall)178691829.49918811.6
 
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.