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

261 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
silvans1030833(None) 
silvan92810151silvan_
silvas92912181silva_s
sylvans13235891sylvans
divans104612392di_vans
oilcans936812oilcans
selvas93812912selva_s
silane62718052sil_ane
silanes72517162sil_anes
silva82714022silva__
silvae92811092silva_e
silvers104714042silvers
silvics1235562silvics
simians959202simians
solans64122492sol_ans
soldans83210402soldans
suldans8299722suldans
sultans72411832sultans
sylvan12257362sylvan_
sylvas12288172sylva_s
sylvins13246242sylvins
alans55636173_al_ans
billons93013363billons
callans94518473callans
clans75031013_cl_ans
cleans85817053_cleans
dioxans1555313dioxans
divan96114843di_van_
divas95418583di_va_s
diwans105110373di_wans
dolmans10479683dolmans
elans55527753_el_ans
firmans12238523firmans
flans85327973_fl_ans
givens10379733gi_vens
glans65125833_gl_ans
gleans75014743_gleans
halvahs16417533halvahs
halvas124714173halva_s
iliads7448673_iliads
invars9310003_invars
island738533isl_and
islands837323isl_ands
kalians11310183kalians
kelvins14106563kelvins
kilns95112983kil__ns
kivas124614733ki_va_s
lallans74113533lallans
leans55536253__leans
ligans76817733li_gans
lignans8398853lignans
lilacs837483lil_acs
limans84816303li_mans
livens94314893li_vens
loans56026463__loans
mikvahs19162493mikvahs
mildens10339933mildens
milpas101710273milpa_s
minivans1345413minivans
minyans1237263minyans
nilgais845203nilgais
nilgaus844003nilgaus
nirvana1042843nirvana
nirvanas1142513nirvanas
oilcan837793oilcan_
oilman839483oilman_
oilways1334873oilways
pavans115715593_pavans
pians75126963pi__ans
pilafs113511023pil_afs
pilaus84114133pil_aus
pilaws11399433pil_aws
pillars9313493pillars
pitmans11188743pitmans
plans75731273_pl_ans
reloans7313133reloans
rivals94213183ri_vals
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
scillas9310473scilla_s
seawans10379943seawans
sedans74816093s_edans
seitans73312303seitans
selahs9313213sel_ahs
selsyns1092943selsyns
selva83014273selva__
selvage1136553selvage
selvages1236513selvages
selves94119613selv_es
servals103410743servals
servant10313633servant
servants1138003servants
sevens93813663s_evens
sewans95215903s_ewans
sextans14349263sextans
shamans123610903shamans
shivahs16375723shivahs
shivas124512413shiva_s
shorans102812413shorans
sialidans1042973sialidans
sials54227243si__als
siamang1045333siamang
siamangs1144063siamangs
siccan1037593siccan_
sickens134411483sickens
siemens938413siemens
siennas736123siennas
sieves93216003siev_es
sieving112311233sieving
sigmas94111363sigma_s
signals8359163signals
signs65516323si__gns
sikas94617023si_ka_s
silage72715303sil_age
silages82514443silages
silds65520523sil__ds
sileni63312143sil_eni
silent64125843sil_ent
silents73514493silents
silenus7369693silenus
silexes1438653silexes
silicas9310603silicas
silicons10107163silicons
silken104410853silken_
silkies113715693silkies
silking123715593silking
silks94620683sil__ks
sillers73822103sillers
sillies73425083sillies
sills55135993sil__ls
siloing83215503siloing
silos56029433sil__os
siloxane1543743siloxane
siloxanes1643613siloxanes
silting83320483silting
silts55330823sil__ts
silver93815813silv_er
silvern10347143silvern
silvery13328093silvery
silvex16336723silv_ex
silvexes1843633silvexes
simars84916933si_mars
simas75727553si_ma_s
simian8811163simian_
simlins9311843simlins
simoons937943simoons
sins46755273si___ns
siphons1239353siphons
sirdars8228213sirdars
sirens65318153si_rens
sirloins836723sirloins
sirrahs10377303sirrahs
sirras63814863sirra_s
sisals63013573si_sals
siskins1159583siskins
sitars65417593si_tars
sithens1039383sithens
sivers95324153si_vers
sizars154812623si_zars
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
slivers104115253slivers
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
spans74528733s__pans
spavins12419323spavins
speans85417143s_peans
splats84817303spl_ats
splays114910873spl_ays
spleens937103spleens
suldan72611043suldan_
sulfas9311563sulfa_s
sultan63012593sultan_
sultana7257803sultana
sultanas8237153sultanas
suntans72111733suntans
swans84625013s__wans
swevens1334613swevens
sylva11268443sylva__
sylvae12236863sylva_e
sylvin12247303sylvin_
sylvine13216543sylvine
sylvines14215903sylvines
tailfans1144553tailfans
tilaks1097353til_aks
titans63414913ti_tans
titians72710453titians
tolans64319273tol_ans
uhlans937573uhl_ans
ulans54921303_ul_ans
ulvas84511503_ulva_s
vans76236733___vans
villains1138013villains
villas96117263villa_s
vivas114815023vi_va_s
volvas12447993volva_s
vulvas12388843vulva_s
wiccans1434603wiccans
wigans104511703wi_gans
witans93412933wi_tans
xylans1635883xyl_ans
yulans958673yul_ans
zillahs1935383zillahs

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 Limit1340272616.81319672.2
3Display Results2612610.0932806.5
 (SQL Overall)1786912617.31224438.0
 
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.