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

139 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
generated1131020(None) 
generate9312901generate_
generates10312711generates
venerated1339951venerated
deaerated11311112deaerated
degenerated1445742degenerated
denervated1545112denervated
enervated1347312_enervated
federated1438422federated
generator1067592generator
penetrated1347302penetrated
regenerated1346902regenerated
venenated1345902venenated
venerate11312902venerate_
venerates12312262venerates
abnegated1344163abnegated
acerated113113983_acerated
acierated1238283acierated
aerated85322373__aerated
asperated1239313asperated
benefited1544173benefited
benempted1642763benempted
berated104422133__berated
celebrated1556223celebrated
cerated103922473__cerated
cerebrated1546343cerebrated
crenelated1375363crenelated
cuneated11310103cune_ated
deaerate9314173deaerate_
deaerates10313643deaerates
decorated13312203decorated
defeated132812163defe_ated
defecated1637493defecated
degenerate1246833degenerate_
degenerates1346453degenerates
delegated1238373delegated
demerited1339073demerited
denervate1346173denervate_
denervates1445933denervates
denigrated1366973denigrated
denitrated1298033denitrated
dentated10411703den_tated
denudated1244933denudated
depurated1338183depurated
derated93623503__derated
desecrated1447953desecrated
deserted101012203deser_ted
deuterated1247533deuterated
elevated12118293_elevated
enervate1148453_enervate_
enervates1248723_enervates
enframed1466263_enframed
engrafted1443733_engrafted
engraved1335813_engraved
enraged93511783_en_raged
entreated10310973_entreated
enumerated13125783_enumerated
everted112711853_ever_ted
execrated1938353_execrated
exenterated1964793exenterated
exerted152210053_exer_ted
exonerated18106003exonerated
federate12310883federate_
federates13310153federates
fenestrated1554243fenestrated
galeated104111573gale_ated
gelated93615633g__elated
geminated1338543geminated
gemmated14336293ge_mmated
gendered11258873gender__ed
genderized2274683genderized
genera71211713genera___
generable1238663generable
general81010933genera__l
generalcy1543423generalcy
generalised13185683generalised
generalized22147443generalized
generally1347343generally
generals9109333genera_ls
generating12310383generating
generation11312423generation
generative1458563generative
generators1147533generators
generatrix1851873generatrix
genette838863gene_tte_
genettes938303gene_ttes
gestated102910573ge_stated
gheraoed1343343g_heraoed
grated84523923g___rated
gyrated12428413g__yrated
hebetated1544663hebetated
innervated1445463innervated
intenerated1247013intenerated
iterated91213823_iterated
itinerated11124933itinerated
lacerated122210673lacerated
leveraged1463783leveraged
liberated1299473liberated
lineated9711063line_ated
macerated142010523macerated
moderated1388143moderated
negated93413233__negated
nonrated9310843non_rated
numerated12177873numerated
operated11512223_operated
penetrate1149233penetrate_
penetrates1248723penetrates
pennated11299543pen_nated
perorated12412463perorated
recrated112918603re_crated
recreated12412533recreated
regelated1139723regelated
regenerate1147963regenerate_
regenerates1247473regenerates
regrated102816333re_grated
reheated122415003rehe_ated
reiterated11410153reiterated
relegated1139763relegated
remunerated1475353remunerated
renegaded1244603renegaded
renested92212953rene_sted
renovated1347173renovated
reoperated1348153reoperated
repeated113117443repe_ated
reseated93220263rese_ated
retreated10312623retreated
reverted122714713rever_ted
sensated938183sen_sated
separated1237713separated
serrated92513433se_rrated
tolerated1049123tolerated
ulcerated1247743ulcerated
uncrated11416313_uncrated
unerased9312773_unerased
unrated82621553_un_rated
vegetated1445083vegetated
venenate1147933venenate_
venenates1247583venenates
venerator1247263venerator

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411396.76621968.8
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.23524698.1
 
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.