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

208 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
sylvan1225736(None) 
silvan92810151silvan
sylva11268441sylva_
sylvae12236861sylvae
sylvans13235891sylvans
sylvas12288171sylvas
sylvin12247301sylvin
selva83014272selva_
selvas93812912selvas
silva82714022silva_
silvae92811092silvae
silvans10308322silvans
silvas92912182silvas
solan55328152sol_an
soldan73511852soldan
suldan72611042suldan
sultan63012592sultan
sylvine13216542sylvine
sylvins13246242sylvins
xylan1537462xyl_an
alan46844083_al_an
asyla839333asyl_a_
bylaw13408603byl_aw
callan83619603callan
clan65633923_cl_an
clean75420413_clean
cyan96419623cy__an
divan96114843_divan
dolman95312403dolman
elan46734243_el_an
eolian6312593eolian
flan76134183_fl_an
flyman14326423flyman
glean65818203_glean
glycan1234903glycan
halva115414433halva_
halvah15499833halvah
halvas124714173halvas
hyla106716513hyl_a_
hylas114815903hyl_as
kalian10312163kalian
kelvin13117323kelvin
lallan63414173lallan
lean46345243__lean
loan47436453__loan
mylar105311533myl_ar
nylon82910513nyl_on
oilcan837793oilcan
oilman839483oilman
pavan106518473_pavan
plan65833943_pl_an
psylla1133953psylla_
psyllas1244883psyllas
pylon103614003pyl_on
pyran10514473py_ran
reloan6415693reloan
ryokan1353753ryokan
salaam8711013salaam
salad65321833sal_ad
salal55425703sal_al
salina64221123salina
saliva93110743saliva_
salivas10309603salivas
salmon84614183salmon
salon55228553sal_on
saloon64418023saloon
salpa75018353salpa_
salpae84614273salpae
salpas85116923salpas
salpian938493salpian
salsa56718923salsa_
salsas65316133salsas
saltant7316773saltant
saltpan935303saltpan
salvage1138193salvage
salve85022133salv_e
salved103916423salved
salver94617753salver
salves94221763salves
salvia93310753salvia
salvias10279933salvias
salving113913153salving
salvo84415643salv_o
salvor94711093salvor
salvos94613383salvos
sampan102511893sampan
saran53730303s_aran
savant9416043s_avant
savin84625083s_avin
scan65530453s__can
seaman84015903seaman
seawan94111223seawan
sedan65620423s_edan
seitan62613233seitan
selah8319613sel_ah
selsyn983843selsyn
selvage1136553selvage
selves94119613selves
serval93913413serval
servant10313623servant
seven84118313s_even
sewan85921293s_ewan
sextan13389643sextan
shaman113314273shaman
shaven124213303shaven
shiva115915003shiva_
shivah15488533shivah
shivas124512413shivas
shoran94016033shoran
siccan1037593siccan
silane62718053sil_ane
silken104410853silken
silver93815813silver
silvern10347133silvern
silvex16336723silvex
simian8811153simian
skean94415623s_kean
skyman1535313skyman
slab67133763s_l_ab
slag55934353s_l_ag
slain54923573s_lain
slam67737973s_l_am
slang66324023s_l_ang
slank95822773s_l_ank
slant55238703s_l_ant
slap66434043s_l_ap
slat46959023s_l_at
slave84224033s_lave
slaw77930713s_l_aw
slay76436383s_l_ay
slogan7539223slogan
sloven9389633sloven
socman1039813socman
sola45541863sol_a_
soland75115043sol_and
solano65314183sol_ano
solans64122493sol_ans
solar55927343sol_ar
soldans83210403soldans
solemn838643solemn
solion6616383solion
solon55026133sol_on
solvate102710213solvate
solve85618943solv_e
solved105312933solved
solvent10310833solvent
solver94016703solver
solves95018223solves
solving112910853solving
soman75024903s_oman
soudan73210353soudan
sovran937153sovran
soybean1243953soybean
span65234663s__pan
spavin114210653spavin
spean74620513s_pean
spelean937123spelean
splat76129343spl_at
splay105816043spl_ay
spleen8310263spleen
stygian1144083stygian
stylar9358113styl_ar
sulcal8311273sulcal
suldans8299723suldans
sulfa8313923sulfa_
sulfas9311563sulfas
sullen62914293sullen
sultana7257803sultana
sultans72411833sultans
suntan62613003suntan
swan76631313s__wan
sweven1235983sweven
syli74318983syl__i
sylis84316023syl_is
syllabi1244983syllabi
sylph1347793syl_ph
sylphs1435543sylphs
sylphy1744153sylphy
sylvanite1543793sylvanite
sylvatic1645353sylvatic
sylvines14215903sylvines
sylvite13266353sylvite
syn67024123sy___n
syngas10368913syngas
syntax1634303syntax
syphon1436853syphon
syren85216743sy_ren
tolan55124013tol_an
tympan13257013tympan
uhlan849113uhl_an
ulan46527393_ul_an
ulpan7310123_ulpan
ulva75412693_ulva_
ulvas84511503_ulvas
valval12398863valval
valvar12388653valvar
van66246323___van
volva11399003volva_
volvas12447993volvas
vulva11448803vulva_
vulvae12438033vulvae
vulval12417663vulval
vulvar12427963vulvar
vulvas12388843vulvas
xylans1635883xyl_ans
yean75834583_y_ean
yuan76120013_y_uan
yulan8411493_yulan

Search took 7 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127162086.07618551.0
3Display Results2082080.0633301.6
 (SQL Overall)1786912086.28228444.9
 
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.