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

129 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
selvaged133434(None) 
salvaged1335351salvaged
selvage1136551selvage_
selvages1236511selvages
salvage1138192salvage_
salvagee1246482salvagee
salvager1235592salvager
salvages1238122salvages
savaged1236992s_avaged
selvedged1541542selvedged
solvated12237442solvated
belaced124112153bel_aced
belated103520013bel_ated
belayed133610083bel_ayed
beleaped1336103beleaped
belonged1235313belonged
cellared11398793cellared
collaged12279963collaged
delated93722873del_ated
delayed123310763del_ayed
deleaded1148333deleaded
deleaved1346573deleaved
deluged10167413del_uged
delved114112753delv__ed
elated74725823_el_ated
elevated12118293_elevated
encaged113211083_encaged
engaged10379833_engaged
enraged93511783_enraged
evaded1137063_e_vaded
fellated1239563fellated
foliaged1344673foliaged
gelated93615633gel_ated
helved134313703helv__ed
herbaged1554523herbaged
melamed1249633mel_amed
meltage1037953meltage_
meltages1148243meltages
messaged1235543messaged
pelage9515363pel_age_
pelages10714613pel_ages
pervaded1535363pervaded
pillaged12298083pillaged
ravaged1236493_ravaged
reimaged1246173reimaged
relaced103517213rel_aced
related83327573rel_ated
relaxed153312523rel_axed
relayed113212753rel_ayed
released9310243released
reloaded1059103reloaded
reloaned939723reloaned
restaged103011853restaged
salaamed1134623salaamed
salivated1337473salivated
salvagees1343673salvagees
salvagers1344693salvagers
salved103916423salv__ed
salvoed11307063salv_oed
savage10410173s_avage_
savager1137133s_avager
savages1139973s_avages
seabed95017693se__abed
sealed74328363se__aled
seamed94823883se__amed
seared75232843se__ared
seated75131053se__ated
sedated93714343se_dated
seepage1037543seepage_
seepages1137283seepages
seesawed1243293seesawed
selected1159783selected
selfed10310913sel__fed
selva83014273selva___
selvas93812913selva__s
selvedge1342043selvedge_
selvedges1442083selvedges
selves94119613selv__es
sensated938183sensated
sepaled10510593se_paled
septage1078403septage_
septages1168263septages
serfage1138403serfage_
serfages1238233serfages
serged84118763se__rged
seriated92717023seriated
serrated92513423serrated
served104616813serv__ed
serviced1435613serviced
severed113513863se_vered
sewage10310733se_wage_
sewages1139753se_wages
shelved14379933shelv__ed
silage72715303sil_age_
silages82514443sil_ages
silvae92811093silva_e_
silvered12237563silvered
slagged104312763s_lagged
slaked114318273s_l_aked
slanged94112853s_langed
slated75028313s_l_ated
slaved104017043s_l_aved
slayed104716223s_l_ayed
sleaved113611133s_leaved
sledged103610313s_ledged
slogged104910463s_logged
sludged103610333s_ludged
slugged104410373s_lugged
solaced102911063sol_aced
solated83618023sol_ated
solvate102710213solvate_
solvates11249673solvates
solved105312933solv__ed
splayed13357813spl_ayed
splodged1333263splodged
splurged1243913splurged
staged84521563s__taged
stellated1046803stellated
stravaged1444193stravaged
sulcated11310373sulcated
sulfated1238833sulfated
sullage859913sullage_
sullages939973sullages
swaged114212253s__waged
sylvae12236863sylva_e_
tallaged10257923tallaged
teenaged10105133teenaged
ullaged937033_ullaged
velveted1533833velveted

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.1731032896.0
2DLD Change Limit1461621297.73318901.1
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.95222471.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.