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

166 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
teenage810805(None) 
teenaged10105131teenaged
teenager9115291teenager
thenage11107841thenage
keelage1236182keelage
menage93216542_menage
peerage1089802peerage
peonage1048722peonage
reengage1045212reengage
seepage1037542seepage
steerage946832steerage
tannage8209582tannage
teenagers10114492teenagers
tenace82715692t_enace
tenge65720442t_en_ge
tentage81010642tentage
ternate7415482ternate
thanage11117942thanage
thenages12107482thenages
tonnage8168052tonnage
tunnage8166372tunnage
alienage945583alienage
apanage1036803apanage
avenge1087553aven_ge
average1158853average
bename103316073_bename
beverage1445143beverage
brewage1347183brewage
carnage10311743carnage
coinage10310553coinage
cozenage2094783cozenage
creepage1344343creepage
crenate93317113crenate
degage92711383_degage
derange939813derange
dunnage9175213dunnage
enate54428153__enate
encage93713503_encage
engage82812103_engage
enrage72715073_enrage
fenagle11197153_fenagle
greengage1243253greengage
grenade938413grenade
henge94819833_hen_ge
herbage1337003herbage
innage73011573_innage
keelages1335743keelages
leafage1194573leafage
leakage1235003leakage
leverage1285393leverage
linage7713403_linage
lineage878983lineage
manage93818903_manage
melange1038363melange
meltage1037953meltage
menace103216943_menace
menages103615393_menages
message1037833message
metage93114453_metage
meterage1147933meterage
neonate7311333neonate
nonage7313683_nonage
overage11514053overage
pawnage1335873pawnage
peage84723573_pe_age
peerages1189893peerages
pelage9515363_pelage
pennae84314033penna_e
penname11328553penname
pennate93314033pennate
peonages1138473peonages
phenate12412203phenate
prename11412643prename
presage10312293presage
reenact9413013reenact
reengaged1244133reengaged
reengages1145343reengages
reenlarge1043173reenlarge
reimage1037913reimage
rename82718813_rename
renege72713763_renege
rennase738713rennase
restage83316193restage
revenge1138573reven_ge
seepages1137283seepages
selenate81712533selenate
selvage1136553selvage
senate63725173_senate
septage1078403septage
serenade9218343serenade
serenate81914883serenate
serfage1138403serfage
sewage10310733_sewage
sewerage1245513sewerage
signage937773signage
spinage10289653spinage
stealage946583stealage
steerages1046493steerages
taeniae739083taeniae
tallage82712073tallage
tanager83010943t_anager
tankage12257773tankage
tannages9228963tannages
tannate71813523tannate
tapenade1145003tapenade
teacake1335453teacake
tease55428713t_e_ase
teaware1048143teaware
teeing73916973teeing_
teen45938203teen___
teener64717503teen_er
teeners74415453teeners
teenful1045563teenful
teenier72611143teenier
teens56227483teen__s
teensier835573teensier
teensy9478273teen_sy
teentsy1034073teentsy
teeny85417883teen__y
teepee8314363tee_pee
teethe94511313tee_the
telae54323293t_ela_e
tenable93214493t_enable
tenaces92814513t_enaces
tenail64516113t_enail
tenant6322473t_enant
teniae64517353t_eniae
tense55225843t_en_se
tentages91011043tentages
tentie62521183t_entie
tenure6311613t_enure
ternary1038343ternary
terne56426153tern__e
terrace93311843terrace
terrae62915213terra_e
terrane72814233terrane
testae64216253testa_e
testate73916233testate
thanages12107623thanages
thecae11299653theca_e
thecate123210023thecate
thenal92712423thena_l
thenar92610003thena_r
thenars10248523thenars
thence112010843then_ce
tillage83111343tillage
tinge64626623t_in_ge
toenail738783toenail
tollage82610163tollage
tonnages9187873tonnages
towage1039833t_owage
treenail846123treenail
treenware1243773treenware
trenail7410813trenail
triage72812893t_riage
tunnages9195903tunnages
tutelage944063tutelage
twinge104210403twin_ge
veena81912323veena__
veenas91410413veena_s
venae85920983_vena_e
venenate1147933venenate
venge95117993_ven_ge
ventage11109623ventage
webpage1543133webpage
weenie92612023ween_ie

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271666.79619721.5
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.26524596.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.