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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

149 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
derivatives184464(None) 
derivative1746681derivative_
derivatizes2445151derivatizes
derivates13310092derivat__es
derivations15611492derivations
derivatively2264312derivatively
derivatize2345982derivatize_
derivatized2554512derivatized
privatives18186472_privatives
definitives1844213definitives
deprivations1897923deprivations
derivate12311203derivat__e_
derivation14712783derivati_on
derivativeness2163803derivativeness
derogative1546983derogative_
deviative1647723devi_ative_
duratives1346223dur__atives
ergatives1346443_er_gatives
fricatives1844683_fricatives
privatises15187403_privatises
privative17188293_privative_
privatizes24156813_privatizes
recitatives1645193recitatives
reprivatizes2653883reprivatizes
adversatives1952474adver_satives
affricatives2351974affricatives
antiderivatives2281354antiderivatives
carminatives1953364carminatives
creatives14279694_cr_eatives
curatives1437824cur__atives
datives11310074d____atives
debilities13411294debiliti_es
decimalizes2546294decimalizes
decimates14410694decimat__es
decimations16410164decimations
declivities1745724decliviti_es
decorative1648924decorative_
dedicatees1445314dedicat_ees
dedicates13311694dedicat__es
dedications15310874dedications
defectives1945684de_fectives
definitive1745084definitive_
definitizes2444684definitizes
degradative1763084degradative_
deities82621924de_i__ti_es
delicacies1545134delicaci_es
delicates12314314delicat__es
delineative1554664delineative_
deliveries1446014deliveri_es
denigrative1655484denigrative_
denominatives1952654denominatives
denotative1456724denotative_
depilates12310924depilat__es
depilations14310904depilations
depravations1885374depravations
depravities1744084depraviti_es
deprivation1788774deprivati_on
derates84028894der__at__es
derisive1247504deri__sive_
derivable1548064deriva_ble_
derivational1654264derivational
derivatizing2654824derivatizing
derives114017814der____ives
dermatitis1344724der_matitis
dermatomes1544304der_matomes
dermatoses1344964der_matoses
derogates11310974derogat__es
derogations1349394derogations
desiccative1953944desiccative_
designative1654334designative_
detectives1645784de_tectives
determinatives2052934determinatives
detonative1447134detonative_
detribalizes2454554detribalizes
deverbatives2152174deverbatives
deviates12312734devi_at__es
deviations14311164devi_ations
devitalizes24107104devitalizes
dilative1239524d__ilative_
diminutives1752584diminutives
directives1655834dir_ectives
dominative1677394dominative_
donatives13146904d__onatives
dramatises1356774d_ramatises
dramatizes2247364d_ramatizes
drivelines1444594d_rivelines
durative1239074dur__ative_
elatives1139784_e__latives
ergative1238974_er_gative_
eruptives1443854_er_uptives
ferities111416714feri__ti_es
fixatives2243354__fixatives
formatives1846214for_matives
fricative1746744_fricative_
genitives1346664geni__tives
germinative1755044germinative_
indicatives1745124indicatives
irritative1345204irritative_
legislatives1651724legislatives
lenitives1247504leni__tives
mediative1548124medi_ative_
mediatizes2245604medi_atizes
meditative1646284meditative_
motivative1844284motivative_
narratives1344794nar_ratives
negatives1346584ne__gatives
nervations1359484ner_vations
nervatures1363524ner_vatures
nominatives1694774nominatives
nonderivative2063514nonderivative_
operatives15117884oper__atives
pejoratives2353504pejoratives
perfectives2145474perfectives
peridotites1454254peridotites
peripatuses1552904peripatuses
peripeties1448394peripeti_es
permeative1748524permeative_
pervasive1744484per_vasive_
prerogatives1853434prerogatives
primitives1745624_primitives
privacies1646804_privaci_es
privates131812374_privat__es
privations15310104_privations
privatise14167764_privatise_
privatised16134994_privatised
privatisms17165954_privatisms
privatists15176054_privatists
privatively2245084_privatively
privatize23167044_privatize_
privatized25195644_privatized
privities14312044_priviti_es
purgatives1643744pur_gatives
recitative1548184recitative_
recitativos1652174recitativos
relatives1239964__relatives
renovative1645434renovative_
reprivatize2554414reprivatize_
reprivatized2753424reprivatized
sedatives1346154se__datives
serialises10811564seri_alises
serializes19912054seri_alizes
seriates82620674seri_at__es
seriations10316684seri_ations
tentatives1345484te_ntatives
terminative1656134terminative_
trivalves1544144_triva_lves
urinative1247654_urinative_
veritates12310974veritat__es
verities111418044veri__ti_es

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.420425454.8
2DLD Change Limit1488191498.72017066.4
3Display Results1491490.0931602.2
 (SQL Overall)1786911499.23319353.5
 
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.