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

97 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
venenate114793(None) 
venenated1345901venenated
venenates1247581venenates
venerate11312901venerate
generate9312902generate
pennate93314032pen_nate
selenate81712532selenate
serenate81914882serenate
vegetate1246672vegetate
venene92912522venen__e
venenose1144022venenose
venerated1339952venerated
venerates12312262venerates
abnegate1144863abnegate
alienate8311553alienate
arsenate81010483arsenate
beneath1236973bene_ath
benzoate1944883benzoate
catenate10312833catenate
conepate12712533conepate
connate9315753con_nate
crenate93317113_crenate
crenelate1176513crenelate
cuneate9311723cune_ate
deaerate9314173deaerate
defecate1438793defecate
delegate10410463delegate
denervate1346173denervate
dentate8315153den_tate
denudate1046163denudate
detente83313603deten_te
detonate9311193detonate
edentate947703_edentate
elevate101110373_elevate
emanate9312473_emanate
emendate1146783_emendate
enate54428153___enate
endnote855743_endnote
enemata948013_enemata
enervate1148463_enervate
ensnare767123_ensnare
entente7412953_enten_te
eventuate12104773eventuate
federate12310883federate
geminate11411813geminate
generated11310203generated
generates10312713generates
genette838863gene_tte
hebetate1347053hebetate
innate63917313_in_nate
lineate7815153line_ate
negate72915573__negate
neonate7311333ne_onate
penetrate1149233penetrate
pennae84314033pen_na_e
penname11328553pen_name
pennated11299543pen_nated
perennate1147783perennate
phenate12412203_phenate
pinnate93613743pin_nate
regelate9312083regelate
relegate9311243relegate
renegade1045123renegade
rennase738713ren_nase
renovate1138553renovate
resinate8316773resinate
resonate8513513resonate
selenates91611363selenates
selenite81713113selenite
senate63725173__senate
sensate7311893sen_sate
serenade9218343serenade
serenata8197673serenata
tannate71813523tan_nate
teenage8108053te_enage
ternate7415483te_rnate
vaginate123911083vaginate
valerate11311473valerate
vanadate1245513vanadate
vedette1166003vede_tte
veena81912323ve_ena__
veenas91410413ve_ena_s
vegetated1445083vegetated
vegetates1346403vegetates
vegete1039483vege__te
velate93720143v__elate
venae85920983v__ena_e
vendace1357363ven_dace
venenating1446013venenating
venenes102712133venen_es
venerable1438483venerable
venerator1247263venerator
vengeance1543853vengeance
venine93718433venin__e
ventage11109623ven_tage
ventilate1248383ventilate
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.406440125.6
2DLD Change Limit146162977.47019566.5
3Display Results97970.0462108.7
 (SQL Overall)178691977.92222556.3
 
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.