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 “passaged” 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
passaged123624(None) 
massaged1236751massaged
passage1039801passage_
passages1139511passages
assayed1135592_assayed
assuaged1044382_assuaged
asswaged1343332_asswaged
massage1039892massage_
massager1136872massager
massages1159882massages
messaged1235542messaged
packaged18115752packaged
passade1039232passade_
passades1139202passades
passed94320942pass__ed
presaged1238802presaged
ansated84214003_ansated
ascared10399523_ascared
ashamed1336243_ashamed
assagai843903_assagai
assagaied1142173_assagaied
assailed945323_assailed
assayer1035573_assayer
assigned1044633_assigned
assuage835683_assuage_
assuager944343_assuager
assuages936273_assuages
assumed1065293_assumed
assured858373_assured
asswage1144673_asswage_
asswages1255053_asswages
balsamed1344543balsamed
bandaged1337313bandaged
barraged1297683barraged
basseted1136743basseted
brassage1145283brassage_
brassages1245263brassages
cabbaged1644383cabbaged
cascaded14135703cascaded
caseated11310713caseated
damaged1257453da_maged
dissaved1337313dissaved
essayed1134013_essayed
garaged1039253ga_raged
gassed85217633gass__ed
hassled11358303hass_led
lassoed8408743lass_oed
managed113212603ma_naged
massacred1443193massacred
massagers1245513massagers
massed94421323mass__ed
message1037833message_
messages1138233messages
mispaged1438243mispaged
package16128013package_
packager17136153packager
packages17138733packages
paged95926783p___aged
palaced124110773pa_laced
palisaded1343563palisaded
palmated132511003palmated
palpated13249763palpated
palsied102911303pals_ied
pancaked1734893pancaked
panged104722333pa__nged
paraded114014263pa_raded
parbaked1735503parbaked
parged104922043pa__rged
parlayed1435813parlayed
parsed96323893pars__ed
parslied1137813parslied
pashed125923143pa_s_hed
passable12310633passable
passably1537253passably
passado1037053passa_do
passadoes1245093passadoes
passados1146303passados
passageway1951093passageway
passaging1345613passaging
passant9813943passa_nt
passband1344773passband
passe75525693pass__e_
passee84522023pass__ee
passel85117003pass__el
passenger1243413passenger
passepied1442933passepied
passer84721033pass__er
passes86030473pass__es
passivated1644143passivated
passive12239593passive_
passives13228823passives
passkey1633563pass_key
passover13135533passover
passuses1036773passuses
password1444843password
pasted94426903pa_s_ted
pastored1139963pastored
pastured1138233pastured
paused95114963paus__ed
pawnage1335873pawnage_
pawnages1435313pawnages
pillaged12298093pillaged
pissed94816933piss__ed
plasmagel1443113plasmagel
plumaged1443573plumaged
plussage1143223plussage_
plussages1243293plussages
portaged12228463portaged
postage103214853postage_
postages112815323postages
preaged11612333p_reaged
presage10312293presage_
presager1138443presager
presages11312203presages
pshawed16103033p_shawed
pulsated1136853pulsated
rampaged1434103rampaged
rassled83310453rass_led
ravaged1236493ra_vaged
repassage1243123repassage_
repassages1343053repassages
restaged103011863restaged
salvaged1335363salvaged
sashayed1543553sashayed
sassed76116173sass__ed
sausage847193sausage_
sausages937003sausages
savaged1236993sa_vaged
staged84521563__staged
swaged114212253__swaged
tallaged10257923tallaged
tasseled935593tasseled
unassayed1343493unassayed
unassuaged1242403unassuaged
upstaged12135243upstaged
visaged1235683_visaged
wassailed1343153wassailed
wastage11109253wastage_
wastages12109753wastages

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.1561145455.1
2DLD Change Limit1461621397.06320694.0
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.28224538.7
 
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.