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
generated1131019(None) 
generate9312891generate_
generates10312701generates
venerated1339941venerated
deaerated11311102deaerated
degenerated1445742degenerated
denervated1545112denervated
enervated1347312_enervated
federated1438412federated
generator1067592generator
penetrated1347292penetrated
regenerated1346902regenerated
venenated1345892venenated
venerate11312892venerate_
venerates12312252venerates
abnegated1344163abnegated
acerated113113983_acerated
acierated1238283acierated
aerated85322373__aerated
asperated1239313asperated
benefited1544173benefited
benempted1642763benempted
berated104422133__berated
celebrated1556213celebrated
cerated103922473__cerated
cerebrated1546333cerebrated
crenelated1375363crenelated
cuneated11310103cune_ated
deaerate9314163deaerate_
deaerates10313623deaerates
decorated13312203decorated
defeated132812163defe_ated
defecated1637493defecated
degenerate1246833degenerate_
degenerates1346443degenerates
delegated1238373delegated
demerited1339073demerited
denervate1346173denervate_
denervates1445923denervates
denigrated1366973denigrated
denitrated1298033denitrated
dentated10411703den_tated
denudated1244933denudated
depurated1338183depurated
derated93623503__derated
desecrated1447943desecrated
deserted101012203deser_ted
deuterated1247523deuterated
elevated12118293_elevated
enervate1148453_enervate_
enervates1248713_enervates
enframed1466263_enframed
engrafted1443733_engrafted
engraved1335813_engraved
enraged93511783_en_raged
entreated10310973_entreated
enumerated13125783_enumerated
everted112711853_ever_ted
execrated1938343_execrated
exenterated1964783exenterated
exerted152210053_exer_ted
exonerated18106003exonerated
federate12310873federate_
federates13310143federates
fenestrated1554243fenestrated
galeated104111573gale_ated
gelated93615633g__elated
geminated1338543geminated
gemmated14336293ge_mmated
gendered11258873gender__ed
genderized2274683genderized
genera71211713genera___
generable1238663generable
general81010933genera__l
generalcy1543423generalcy
generalised13185683generalised
generalized22147413generalized
generally1347343generally
generals9109333genera_ls
generating12310383generating
generation11312423generation
generative1458563generative
generators1147533generators
generatrix1851863generatrix
genette838863gene_tte_
genettes938303gene_ttes
gestated102910573ge_stated
gheraoed1343343g_heraoed
grated84523923g___rated
gyrated12428413g__yrated
hebetated1544663hebetated
innervated1445463innervated
intenerated1247013intenerated
iterated91213813_iterated
itinerated11124933itinerated
lacerated122210673lacerated
leveraged1463783leveraged
liberated1299473liberated
lineated9711063line_ated
macerated142010523macerated
moderated1388143moderated
negated93413233__negated
nonrated9310843non_rated
numerated12177873numerated
operated11512223_operated
penetrate1149223penetrate_
penetrates1248713penetrates
pennated11299543pen_nated
perorated12412443perorated
recrated112918583re_crated
recreated12412533recreated
regelated1139723regelated
regenerate1147963regenerate_
regenerates1247463regenerates
regrated102816323re_grated
reheated122415003rehe_ated
reiterated11410143reiterated
relegated1139763relegated
remunerated1475353remunerated
renegaded1244603renegaded
renested92212953rene_sted
renovated1347173renovated
reoperated1348143reoperated
repeated113117443repe_ated
reseated93220263rese_ated
retreated10312613retreated
reverted122714713rever_ted
sensated938183sen_sated
separated1237713separated
serrated92513423se_rrated
tolerated1049123tolerated
ulcerated1247743ulcerated
uncrated11416313_uncrated
unerased9312773_unerased
unrated82621553_un_rated
vegetated1445073vegetated
venenate1147923venenate_
venenates1247573venenates
venerator1247253venerator

Search took 10 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.1561145455.1
2DLD Change Limit1486411398.83016833.6
3Display Results1391390.140992.9
 (SQL Overall)1786911399.12619580.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.