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

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

145 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
derivate1231120(None) 
derivates13310091derivates
decimate13411122decimate
dedicate12312802dedicate
delicate11315492delicate
depilate11311702depilate
derate74531232der__ate
derivable1548062derivable
derivative1746682derivative
derivatize2345982derivatize
derive103817042deriv__e
derogate10311352derogate
deviate11312712devi_ate
nervate1039522ner_vate
private121513262_private
seriate73722472seri_ate
acervate1336983acer_vate
activate13510373activate
aerate64830553aer__ate
aestivate12127663aestivate
berate84729023ber__ate
carinate103320243carinate
celibate1259313celibate
cerate84829463cer__ate
cerite84724873ceri__te
deactivate1644623deactivate
deaerate9314173deaerate
dealate83617843de_alate
deaminate12410173deaminate
debate94419193de__bate
deciare10710663deci_are
deciduate1345063deciduate
decimated1548953decimated
decimates14410693decimates
decorate11315193decorate
dedicated14310253dedicated
dedicatee13410343dedicatee
dedicates13311693dedicates
defecate1438793defecate
defilade13124433defilade
definite1239323definite
deflate113613943de_flate
delate73827753de__late
delegate10410463delegate
delicates12314313delicates
delineate1047793delineate
demivolte1542803demivolte
denervate1346173denervate
denigrate1168693denigrate
denitrate10810533denitrate
dentate8315153de_ntate
denudate1046163denudate
depilated1339653depilated
depilates12310923depilates
deprecate1477433deprecate
depredate1345723depredate
deprival1444603depriva_l
deprivals1543533deprivals
deprive1338303depriv__e
depurate1139983depurate
deracinate1356563deracinate
derat65044083der__at_
derated93623503der__ated
derates84028893der__ates
derats74625063der__ats
deride84420033deri__de
derisive1247503derisive
derivation14712783derivation
derivatives1844643derivatives
derivatized2554513derivatized
derivatizes2445153derivatizes
derived123912763deriv_ed
deriver114213913deriv_er
derivers123811363derivers
derives114017813deriv_es
deriving132510743deriving
derogated1238673derogated
derogates11310973derogates
desiccate1445923desiccate
designate1147113designate
desolate9411993desolate
detonate9311193detonate
deviated13311043devi_ated
deviates12312733devi_ates
devote104513783de__vote
digitate1098683digitate
dilate73220693d__ilate
dominate11312853dominate
drivable1438023d_rivable
drive95318003d_riv__e
elevate101110373_elevate
emirate91015833_emirate
enervate1148453ener_vate
epilate9314283_epilate
ergate7315143_er_gate
estivate111010003estivate
feriae95618603feri_a_e
fermate122813003fer_mate
ferrate103014043fer_rate
frigate11311063_frigate
geminate11411803geminate
germinate1248623germinate
heritage1246533heritage
herniate1148113herniate
hesitate1169973hesitate
irrigate967633irrigate
irritate867873irritate
levigate1246623levigate
levirate1147623levirate
levitate1137933levitate
loricate10310663loricate
marinate103017783marinate
mediate103415213medi_ate
medicate13513243medicate
meditate11310623meditate
metricate1349913metricate
motivate1347693motivate
muriate9313363muri_ate
muricate12311113muricate
periodate1248343periodate
permeate12311613permeate
perorate10417923perorate
pervade1337023per_vade
primate111516283_primate
privater13158533_privater
privates131812373_privates
pyruvate1643073pyruvate
renovate1138553renovate
resinate8316773resinate
rivage1038843__rivage
salivate11310013salivate
serenate81914883serenate
seriated92717023seri_ated
seriates82620673seri_ates
serrate73017543ser_rate
striate74218953stri_ate
suricate10312613suricate
terminate11411203terminate
ternate7415483ter_nate
titivate1146803titivate
urinate7315363_urinate
variate101316433vari_ate
veritates12310973veritates
verite94323443veri__te
vesicate131210053vesicate

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621457.17020385.2
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.38924183.4
 
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.