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

94 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
delineative155466(None) 
deliberative1854052deliberative
delineate1047792delineat__e
delineating1346372delineating
delineation1247762delineation
definitive1745083defin_itive
degenerative1754963degenerative
delineated1246243delineat_ed
delineates1147123delineat_es
delineations1346763delineations
delineator1174173delineat_or
delineators1253963delineators
denigrative1655483denigrative
derivative1746683deri_vative
desiccative1953943desiccative
desiderative1753683desiderative
designative1654333designative
detonative1447133deton_ative
deviative1647723devi__ative
dominative1677393domin_ative
meliorative1655153meliorative
alliterative1553874alliterative
ameliorative1752944ameliorative
deceptive1746854de__ceptive
declarative1754314declarative
declination14411874declin_ation
decongestive1952394decongestive
decorative1648924de_corative
decretive1547494de_cre_tive
defective1848004de__fective
definitives1844214defin_itives
definitize2344674defin_itize
deflective1956094de_flective
deformative2044974deformative
degradative1763084degradative
deleave1147724del__ea__ve
deliberate1347124deliberat__e
deliberating1645124deliberating
deliberation1546364deliberation
deliberatively2372014deliberatively
delicate11315494deli_cat__e
demineralize2484864demineralize
demonetize2245584demone_tize
denominative1854404denomin_ative
denotative1456724de_notative
denotive1238674de__n_otive
denunciative18112794denunciative
depletive1545624de_ple_tive
derivatives1844644deri_vatives
derivatize2345984deri_vatize
derogative1546984de_rogative
detective1548104de__tective
devastative1853434devastative
deverbative2053624deverbative
digestive1446244d__igestive
dilative1239524d__i_lative
diminutive1653394dimin_utive
directive1557774d__irective
disincentive1853394disincentive
donative12139874d__on_ative
duplicative1954174dupli_cative
elative10312454_el___ative
elective13311004_el__ective
eliminative1654364_eliminative
emanative1447314_eman_ative
exonerative2155394_exonerative
generative1458564ge__nerative
germinative1755044germin_ative
ideative1238574___ideative
insinuative1454024insinuative
legislative1552674legislative
ligative1258804__li_gative
linearise946434__linearise
linearize1845754__linearize
lineate7815154__lineat__e
lineation9310764__lineation
mediative1548124medi__ative
meditative1646284medi_tative
nominative1597684nomin_ative
obliterative1753054obliterative
permeative1748524pe_rmeative
recitative1548184reci_tative
recreative1549024re_creative
regenerative1655304regenerative
reiterative1447534re_iterative
relative11313144rel___ative
remunerative1754764remunerative
replicative1846084repli_cative
ruminative1546434rumin_ative
selective1449524sel__ective
seronegative1652694seronegative
tentative1247814te__ntative
terminative1656134termin_ative
urinative1247654_urin_ative

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 Limit148819949.07616397.0
3Display Results94940.0501880.0
 (SQL Overall)178691949.54918713.1
 
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.