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

156 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
delegate1041046(None) 
delegated1238371delegated
delegatee1148811delegatee
delegates1139841delegates
relegate9311241relegate
ablegate1147252ablegate
deaerate9314172deaerate
defecate1438792defecate
delate73827752del__ate
deleave1147722dele_ave
delectate1248742delectate
delegable13136642delegable
delegacy1543532delegacy
delegatees1244272delegatees
delegator1146242delegator
delete73620702dele__te
delicate11315492delicate
derogate10311352derogate
elevate101110372_elevate
legate72917452__legate
relegated1139762relegated
relegates10310942relegates
selenate81712532selenate
ablegates1246803ablegates
abnegate1144863abnegate
celebrate1348093celebrate
celeste949653cele_ste
celibate1259313celibate
cellmate1237873cellmate
deaerated11311123deaerated
deaerates10313643deaerates
dealate83617843de_alate
debate94419193d__ebate
decease1049523dece_ase
decelerate1347513decelerate
decimate13411123decimate
decorate11315193decorate
dedicate12312803dedicate
defeat103817163defe_at_
defeated132812163defe_ated
defeater122611663defe_ater
defeats113511233defe_ats
defecated1637493defecated
defecates1538593defecates
deflagrate15143403deflagrate
deflate113613943de_flate
degage92711383d__egage
degame102713183d__egame
delated93722873del__ated
delates83526283del__ates
delead84112343dele_a_d
deleaded1148333dele_aded
deleads9379703dele_ads
deleaved1346573dele_aved
deleaves1248063dele_aves
delectated1446723delectated
delectates1348193delectates
delegacies1444033delegacies
delegating1337673delegating
delegation1238883delegation
delegators1245633delegators
deletable12149503deletable
deleted93314913dele__ted
deletes83117933dele__tes
deliberate1347123deliberate
delicates12314313delicates
delight12610673delight_
delighted1546203delighted
delighter1445583delighter
delights1347333delights
delineate1047793delineate
deluge8189403delug__e
denervate1346173denervate
denigrate1168693denigrate
dentate8315153de_ntate
denudate1046163denudate
depilate11311703depilate
deplete103010423deple__te
deprecate1477433deprecate
depredate1345733depredate
depurate1139983depurate
derate74531233d__erate
deregulate12135193deregulate
derivate12311203derivate
derogated1238683derogated
derogates11310973derogates
desecrate1249083desecrate
designate1147113designate
desolate9411993desolate
desperate12410843desperate
detente83313603dete_nte
detonate9311193detonate
deuterate1049513deuterate
deviate11312713de_viate
dilatate947773dilatate
dilate73220693dil__ate
divagate1344783divagate
dolerite9611773dolerite
elate55335883_el__ate
elegance1146373_elegance
elegant8311503_elegant
elegise8139393_elegise
elegit71212893_elegit_
elegits8149343_elegits
elegize17127383_elegize
elevated12118293_elevated
elevates111110423_elevates
elongate945613_elongate
eluate62315433_el_uate
ergate7315143_e_rgate
exegete1545773_exegete
federate12310883federate
fellate10313433fel_late
galeate83916793gale_ate
gelate73421263gel__ate
generate9312903generate
headgate1346483headgate
hebetate1347053hebetate
helpmate1545603helpmate
legated92513983__legated
legatee82814633__legatee
legates82917683__legates
legato72810953__legato
levigate1246623levigate
ligate72519253__ligate
maleate94117543male_ate
negate72915573__negate
nondelegate1353173nondelegate
obligate11198303obligate
oleate6318883_ole_ate
paleate94120003pale_ate
peltate92013773pel_tate
pileate93815923pile_ate
reelevate1245663reelevate
regelate9312083regelate
relate64033633rel__ate
release7312763rele_ase
relegable1258103relegable
relocate10713533relocate
renegade1045133renegade
segregate1145073segregate
selenates91611363selenates
selenite81713113selenite
serenate81914883serenate
telega736773telega__
telegas837443telega_s
telepath1345143telepath
tolerate8312323tolerate
tollgate946253tollgate
undelegated1444073undelegated
valerate11311473valerate
vegetate1246673vegetate
velate93720143vel__ate
venenate1147933venenate
venerate11312903venerate
vulgate11388433vul_gate

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 Limit1461621567.18620339.8
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.67223291.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.