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

108 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
teenaged1010513(None) 
teenage8108051teenage_
teenager9115291teenager
reengaged1244132reengaged
teenagers10114492teenagers
thenage11107832thenage_
thenages12107472thenages
avenged1245503aven_ged
averaged1356213averaged
benamed122911093_benamed
crenated113013913crenated
deejayed2042443deejayed
defanged1435433defanged
deranged1137693deranged
encaged113211083_encaged
engaged10379833_engaged
enraged93511783_enraged
fenagled13184853_fenagled
heehawed1842733heehawed
hennaed1135103henna_ed
herbaged1554523herbaged
keelage1236183keelage_
keelages1335743keelages
keened114013623keen__ed
leveraged1463783leveraged
managed113212603_managed
menaced122710093_menaced
menage93216543_menage_
menages103615393_menages
messaged1235543messaged
overaged13511673overaged
peened94318153peen__ed
peerage1089803peerage_
peerages1189883peerages
pennated11299543pennated
peonage1048723peonage_
peonages1138473peonages
preaged11612333pre_aged
presaged1238803presaged
reenacted1236853reenacted
reengage1045213reengage_
reengages1145343reengages
reenlarged1242653reenlarged
rehanged1357833rehanged
reimaged1246173reimaged
renamed103114523_renamed
reneged92010763_reneged
restaged103011853restaged
revenged1337553reven_ged
seepage1037543seepage_
seepages1137283seepages
seesawed1243293seesawed
selvaged1334343selvaged
serenaded11215933serenaded
steerage946833steerage_
steerages1046483steerages
tallaged10257923tallaged
tanager83010943t_anager
tanged84622493t_an_ged
tannage8209583tannage_
tannages9228963tannages
teamed95418593t_e_amed
teared75722153t_e_ared
teased74721153t_e_ased
teated74924023t_e_ated
teemed95114873tee__med
teener64717503teen__er
teenier72611143teen_ier
teensier835573teensier
teetered9258303teetered
teethed11318623tee_thed
telneted935073telneted
tenace82715693t_enace_
tenaces92814513t_enaces
tenanted937043t_enanted
tended83819483t_en_ded
tenge65720433t_en_ge_
tenoned839363t_enoned
tensed74817833t_en_sed
tentage81010643tentage_
tentages91011043tentages
tented74221003t_en_ted
tenured838363t_enured
ternate7415483ternate_
terraced11318113terraced
thanage11117933thanage_
thanages12107603thanages
thonged12376833thon_ged
tinged84220793t_in_ged
toenailed1043483toenailed
tonged86518903t_on_ged
tonnage8168053tonnage_
tonnages9187873tonnages
treaded95014283tre_aded
treated83618703tre_ated
trenched14289853trenched
trended94011763tren_ded
triaged92810443t_riaged
tunnage8166373tunnage_
tunnages9195903tunnages
twanged12387273twan_ged
tweaked1534403twe_aked
twinged12398353twin_ged
unaged83916423__unaged
unengaged1243013unengaged
venenated1345893venenated
venged114011983_ven_ged
weened104013733ween__ed

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.1731032896.0
2DLD Change Limit1461621088.75016704.2
3Display Results1081080.0462347.8
 (SQL Overall)1786911088.96919923.2
 
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.