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

163 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
generate931290(None) 
generated11310201generated
generates10312711generates
venerate11312901venerate
deaerate9314172deaerate
degenerate1246832degenerate
denervate1346172denervate
enervate1148452_enervate
federate12310882federate
genera71211712genera__
generable1238662generable
general81010932genera_l
generals9109332generals
generative1458562generative
generator1067592generator
genette838862gene_tte
penetrate1149232penetrate
regenerate1147962regenerate
venenate1147932venenate
venerated1339952venerated
venerates12312262venerates
abnegate1144863abnegate
acerate92818913_acerate
acierate10311813acierate
aerate64830553__aerate
ameerate1039633ameerate
asperate10312373asperate
beneath1236973bene_ath
benzoate1944883benzoate
berate84729023__berate
beverage1445143beverage
celebrate1348083celebrate
cerate84829463__cerate
cerebrate1348653cerebrate
conepate12712533conepate
crenelate1176513crenelate
cuneate9311723cune_ate
deaerated11311113deaerated
deaerates10313643deaerates
decorate11315193decorate
defecate1438793defecate
degenerated1445743degenerated
degenerates1346453degenerates
delegate10410463delegate
dendrite1048783dendrite
denervated1545113denervated
denervates1445933denervates
denigrate1168693denigrate
denitrate10810533denitrate
dentate8315153den_tate
denudate1046163denudate
depurate1139983depurate
derate74531233__derate
desecrate1249083desecrate
desperate12410843desperate
deuterate1049513deuterate
elevate101110373_elevate
emeerate10410103emeerate
emirate91015833_emirate
enate54428143_en__ate
enemata948013_enemata
enervated1347313_enervated
enervates1248723_enervates
enframe1247363_enframe
engrave1137133_engrave
enrage72715073_en_rage
enumerate11127353_enumerate
execrate1739653_execrate
exenterate1795683exenterate
exonerate16107733exonerate
federated1438423federated
federates13310153federates
fenestrate1345293fenestrate
ferrate103014043fe_rrate
galeate83916783gale_ate
gelate73421253g__elate
geminate11411803geminate
gemmate12418383ge_mmate
gendarme1243523gendarme
genderize2065673genderize
generalcy1543423generalcy
generalise11178123generalise
generality1446193generality
generalize20198453generalize
generally1347343generally
generating12310383generating
generation11312423generation
generators1147533generators
generatrix1851873generatrix
generic101310753gener_ic
generics11118793generics
generous939773generous
genet66038683gene__t_
genets75716663gene__ts
genettes938303gene_ttes
geneva1085853geneva__
genevas1185253geneva_s
genre66016803gen_r__e
gentrice1148813gentrice
gestate83614073ge_state
geyserite1353933geyserite
glabrate1146033glabrate
glomerate1245673glomerate
grate64932883g___rate
gyrate104912523g__yrate
hebetate1347053hebetate
ingrate8715123_ingrate
innervate1246593innervate
intenerate1048733intenerate
iterate71119113_iterate
itinerate9116253itinerate
lacerate102214703lacerate
leverage1285393leverage
levirate1147623levirate
liberate101113383liberate
lineate7815153line_ate
literate81216893literate
macerate122314073macerate
meterage1147933meterage
moderate11710993moderate
negate72915573__negate
nervate1039523__nervate
numerate101610393numerate
operate9615733_operate
overate10620963_overate
peerage1089803pe_erage
penetrated1347303penetrated
penetrates1248723penetrates
pennate93314033pen_nate
perorate10417923perorate
recrate92621663re_crate
recreate10313603recreate
regelate9312083regelate
regenerated1346903regenerated
regenerates1247473regenerates
regrate82618663re_grate
reiterate9412933reiterate
relegate9311243relegate
remunerate1266253remunerate
renegade1045123renegade
renovate1138553renovate
reoperate11410183reoperate
selenate81712523selenate
senate63725143sen__ate
sensate7311883sen_sate
separate10310783separate
serenate81914883serenate
serrate73017543se_rrate
sewerage1245513sewerage
temperate1348513temperate
tenebrae1044873tenebra_e
tenorite8311993tenorite
tolerate8312323tolerate
ulcerate1039733ulcerate
uncrate9415953_uncrate
underate9918603underate
valerate11311473valerate
vegetate1246673vegetate
venenated1345903venenated
venenates1247583venenates
venerable1438483venerable
venerator1247263venerator
wernerite1245173wernerite

Search took 9 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 Limit1461621638.18617855.1
3Display Results1631630.0762144.7
 (SQL Overall)1786911638.41821227.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.