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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
enervate114845(None) 
denervate1346171denervate
enervated1347311enervated
enervates1248721enervates
nervate1039521_nervate
acervate1336982acervate
denervated1545112denervated
denervates1445932denervates
elevate101110372ele_vate
enervator1245522enervator
generate9312902gener_ate
innervate1246592innervate
venerate11312902vener_ate
acerate92818913acer_ate
acerbate1247533acerbate
aerate64830553_aer_ate
berate84729023_ber_ate
cerate84829463_cer_ate
deaerate9314173deaer_ate
derate74531233_der_ate
derivate12311203_derivate
edentate947703edentate
elevated12118293ele_vated
elevates111110423ele_vates
emeerate10410103emeerate
emendate1146763emendate
emeritae1046353emeritae
emirate91015833emir_ate
enate54428153en___ate
endplate1147083endplate
enemata948013ene_mata
energise947333energise
energize1845563energize
enervating1488433enervating
enervation1369473enervation
enervators1345703enervators
enframe1247363enfr_ame
engrave1137133engr_ave
enrage72715073en_r_age
entreat7315263entreat_
entreated10310973entreated
entreats839773entreats
entreaty1146173entreaty
enumerate11127353enumer_ate
enwreathe1552863enwreathe
ergate7315143__ergate
estivate111010003estivate
excavate2045053excavate
execrate1739653execrate
exonerate16107733exoner_ate
federate12310883feder_ate
fermate122813003_fermate
ferrate103014043_ferrate
generated11310203gener_ated
generates10312713gener_ates
increate10312203increate
incurvate1446053incurvate
inebriate1146633inebriate
ingrate8715123ingr_ate
innervated1445463innervated
innervates1346383innervates
innovate1145643innovate
intervale12911583intervale
iterate71119113iter_ate
narrate7313493_narrate
negate72915573_ne_gate
neonate7311333_neonate
nervature1263823_nervature
nerve86617373_nerv__e
nervine102510623_nervine
nervule1044943_nervule
nervure1034973_nervure
operate9615733oper_ate
overate10620963over_ate
overhate14312793overhate
overlate11716283overlate
overrate11615693overrate
overvote1438953overvote
penetrate1149233penetrate
pervade1337023_pervade
recurvate1445853recurvate
reinnervate1453323reinnervate
renovate1138553ren_ovate
seriate73722473_seriate
serrate73017543_serrate
ternate7415483_ternate
uncrate9415953uncr_ate
uncreate10311353uncreate
underate9918603under_ate
underrate10411893underrate
undervote1357753undervote
unornate848013unornate
venenate1147933vene_nate
venerated1339953vener_ated
venerates12312263vener_ates

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.423422437.4
2DLD Change Limit146162957.37619815.9
3Display Results95950.0303166.7
 (SQL Overall)178691957.82922824.2
 
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.