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

178 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
sylvans1323589(None) 
silvans10308331silvans
sylvan12257361sylvan_
sylvas12288171sylva_s
sylvins13246241sylvins
selvas93812912selva_s
silvan92810152silvan_
silvas92912182silva_s
solans64122492sol_ans
soldans83210402soldans
suldans8299722suldans
sultans72411832sultans
sylva11268442sylva__
sylvae12236862sylva_e
sylvin12247302sylvin_
sylvine13216542sylvine
sylvines14215902sylvines
xylans1635882xyl_ans
alans55636173_al_ans
bylaws14415833byl_aws
callans94518473callans
clans75031013_cl_ans
cleans85817053_cleans
cyans105714813cy__ans
divans104612393_divans
dolmans10479683dolmans
elans55527753_el_ans
flans85327973_fl_ans
glans65125833_gl_ans
gleans75014743_gleans
glycans1344233glycans
halvahs16417533halvahs
halvas124714173halva_s
hylas114815903hyl_a_s
kalians11310183kalians
kelvins14106563kelvins
lallans74113543lallans
leans55536253__leans
loans56026463__loans
mylars114310443myl_ars
nylons9267973nyl_ons
oilcans936813oilcans
pavans115715593_pavans
plans75731273_pl_ans
psyllas1244883psylla_s
pylons113011243pyl_ons
pyrans11411063py_rans
reloans7313133reloans
ryokans1443293ryokans
salaams997703salaams
salads75316963sal_ads
salals65120083sal_als
salinas73116093salinas
salivas10309603saliva_s
salmons93713263salmons
salons63823693sal_ons
saloons74415323saloons
salpas85116923salpa_s
salpians1036763salpians
salsas65316133salsa_s
saltant7316773saltant
saltpans1034813saltpans
salvage1138193salvage
salvages1238123salvages
salvers103916003salvers
salves94221763salv_es
salvias10279933salvias
salving113913153salving
salvoes102811313salvoes
salvors103910913salvors
salvos94613383salv_os
sampans112411003sampans
sans45153363s___ans
sarans64224433s_arans
savant9416043s_avant
savants1038653s_avants
savins93923133s_avins
scans74625103s__cans
seawans10379943seawans
sedans74816093s_edans
seitans73312303seitans
selahs9313213sel_ahs
selsyns1092943selsyns
selva83014273selva__
selvage1136553selvage
selvages1236513selvages
selves94119613selv_es
servals103410753servals
servant10313633servant
servants1138003servants
sevens93813663s_evens
sewans95215903s_ewans
sextans14349273sextans
shamans123610903shamans
shivahs16375723shivahs
shivas124512413shiva_s
shorans102812413shorans
silane62718053sil_ane
silanes72517163sil_anes
silva82714023silva__
silvae92811093silva_e
silvers104714043silvers
silvics1235563silvics
simians959203simians
skeans104512913s_keans
slabs75322643s_l_abs
slags66525903s_l_ags
slams74927903s_l_ams
slang66324023s_l_ang
slangs75615343s_l_angs
slank95822773s_l_ank
slant55238703s_l_ant
slants64819083s_l_ants
slaps76025713s_l_aps
slats55436903s_l_ats
slaves95023023s_laves
slaws85222713s_l_aws
slays85723683s_l_ays
slogans8407983slogans
slovens10316573slovens
solan55328153sol_an_
soland75115043sol_and
solands84412343sol_ands
solano65314183sol_ano
solanos74412853sol_anos
soldan73511853soldan_
solions7513753solions
solons65120023sol_ons
solvate102710213solvate
solvates11249673solvates
solvent10310833solvent
solvents1136763solvents
solvers104414253solvers
solves95018223solv_es
solving112910853solving
somans84619303s_omans
soudans8309353soudans
sovrans1036483sovrans
sowans94215893s_owans
soybeans1343283soybeans
spans74528733s__pans
spavins12419323spavins
speans85417143s_peans
splats84817303spl_ats
splays114910873spl_ays
spleens937103spleens
suldan72611043suldan_
sulfas9311563sulfa_s
sultan63012593sultan_
sultana7257803sultana
sultanas8237153sultanas
suntans72111733suntans
swans84625013s__wans
swevens1334613swevens
sylis84316023syl__is
syllabi1244983syllabi
syllabus1343813syllabus
sylphs1435543syl_phs
sylvanite1543793sylvanite
sylvanites1643283sylvanites
sylvatic1645353sylvatic
sylvite13266353sylvite
sylvites14225843sylvites
syngas10368913synga_s
syphons1537503syphons
syrens94911993sy_rens
tolans64319273tol_ans
tympans14236813tympans
uhlans937573uhl_ans
ulans54921303_ul_ans
ulvas84511503_ulva_s
vans76236743___vans
volvas12447993volva_s
vulvas12388843vulva_s
xylan1537463xyl_an_
yeans86624883_y_eans
yuans84613323_y_uans
yulans958673_yulans

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271786.43620824.6
3Display Results1781780.0632825.4
 (SQL Overall)1786911786.91925826.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.