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

227 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
sylvae1223686(None) 
silvae92811091silvae
sylva11268441sylva_
sylvan12257361sylvan
sylvas12288171sylvas
salpae84614272salpae
salvage1138192salvage
salve85022132salv_e
selva83014272selva_
selvage1136552selvage
selvas93812912selvas
silva82714022silva_
silvan92810152silvan
silvas92912182silvas
slave84224032s_lave
solvate102710212solvate
solve85618942solv_e
sylvans13235892sylvans
sylvin12247302sylvin
sylvine13216542sylvine
sylvite13266352sylvite
vulvae12438032vulvae
alae45643753_al_ae
algae65319623_algae
asyla839333asyl_a_
blae66134643_bl_ae
bullae83416163bullae
bylaw13408603byl_aw
byline11311643byline
calve105919923calv_e
cellae84915933cellae
clave105420153_clave
culpae10389263culpae
cymae126713013cy_mae
delve96018263delv_e
galeae74717453galeae
gyve116215083gy_v_e
halva115414433halva_
halvah15499833halvah
halvas124714173halvas
halve114818923halv_e
helve115018093helv_e
hydrae13258573hydrae
hyla106716513hyl_a_
hylas114815903hyl_as
hyphae1746433hyphae
larvae938843larvae
lave75642143__lave
lyttae994713lyttae
mylar105311533myl_ar
novae85913123_novae
paleae84820293paleae
phylae14458733phyl_ae
psylla1133953psylla_
psyllas1244883psyllas
sae38365183s___ae
salaam8711013salaam
salad65321833sal_ad
salal55425703sal_al
sale44959703sal__e
saline65132703saline
saliva93110743saliva_
salivas10309603salivas
salivate11310013salivate
salpa75018353salpa_
salpas85116923salpas
salsa56718923salsa_
salsas65316133salsas
saltie63422423saltie
salute64418023salute
salvable1338403salvable
salvaged1335353salvaged
salvagee1246483salvagee
salvager1235593salvager
salvages1238123salvages
salved103916423salved
salver94617753salver
salves94221763salves
salvia93310753salvia
salvias10279933salvias
salvo84415643salv_o
salvoed11307063salvoed
salvoes102811313salvoes
salvor94711093salvor
salvos94613383salvos
savage10410173s_avage
savate9313783s_avate
save75741363s_av_e
sclerae937933sclerae
selah8319613sel_ah
selkie102811693selkie
selle54428313sel_le
selvaged1334343selvaged
selvages1236513selvages
selves94119613selves
serval93913413serval
serve85425963serv_e
setae56026223s_etae
shave114425893shav_e
shavie124312413shavie
sheave124514003sheave
shelve124012763shelv_e
shiva115915003shiva_
shivah15488533shivah
shivas124512413shivas
shive114423423shiv_e
shove114421033shov_e
sieve84918843siev_e
silage72715303silage
silane62718053silane
silkie103313403silkie
silvans10308323silvans
silver93815813silver
silvex16336723silvex
skive124614113skiv_e
skylike1336103skylike
skyline1436793skyline
slab67133763s_l_ab
slag55934353s_l_ag
slake93724053s_lake
slam67737973s_l_am
slap66434043s_l_ap
slat46959023s_l_at
slate55438283s_late
slaved104017043s_laved
slaver94419613s_laver
slaves95023023s_laves
slavey124011803s_lavey
slaw77930713s_l_aw
slay76436383s_l_ay
sleave94714153s_leave
sleaze152611863s_leaze
slice74925823s_lice
slide64725413s_lide
slime74925753s_lime
slipe75626133s_lipe
sloe45534953s_l_oe
slope75823563s_lope
slue45332193s_l_ue
slype105112363s_lype
soave84219053soav_e
sola45541863sol_a_
solace83415823solace
solan55328153sol_an
solar55927343sol_ar
solate64526073solate
soldan73511853soldan
sole46053673sol__e
solute64016663solute
solvable1337473solvable
solvated12237443solvated
solvates11249673solvates
solved105312933solved
solver94016703solver
solves95018223solves
spae65034323s__pae
spavie113611383spavie
spicae104313703spicae
splake1259783splake
splat76129343spl_at
splay105816043spl_ay
splice104915103splice
spline86020533spline
splore81611303splore
stave85324993stav_e
stelae63716483stelae
stoae55024263s_toae
stove85220253stov_e
striae65422273striae
stylar9358113styl_ar
stylate10179773stylate
style85519363styl__e
stylise10208953stylise
stylite10219613stylite
stylize19177453stylize
suave83519873suav_e
sulcal8311273sulcal
sulcate9314423sulcate
suldan72611043suldan
sulfa8313923sulfa_
sulfas9311563sulfas
sulfate10311653sulfate
sullage859913sullage
sultan63012593sultan
summae103911013summae
sundae7312873sundae
swive115316193swiv_e
syce95820283sy__ce
sycee105018623sy_cee
syke115420563sy__ke
syli74318983syl__i
sylis84316023syl_is
syllabi1244983syllabi
syllable13177773syllable
sylph1347793syl_ph
sylphs1435543sylphs
sylphy1744153sylphy
sylvanite1543793sylvanite
sylvatic1645353sylvatic
sylvines14215903sylvines
sylvins13246243sylvins
sylvites14225843sylvites
syne75725763sy__ne
syngas10368913syngas
syntax1634303syntax
synurae1044253synurae
telae54323293tel_ae
ulnae55214573_ulnae
ulva75412693_ulva_
ulvas84511503_ulvas
valval12398863valval
valvar12388653valvar
valvate133710813valvate
valve114515933valv_e
villae95615383villae
volva11399003volva_
volvas12447993volvas
volvate13317993volvate
vulva11448803vulva_
vulval12417663vulval
vulvar12427963vulvar
vulvas12388843vulvas
vulvate13388323vulvate
wyle105519383wyl__e
xylan1537463xyl_an
xylene1645793xylene
xylose1636763xylose

Search took 9 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.1401276364.3
2DLD Change Limit1127162277.92014231.8
3Display Results2272270.0802837.5
 (SQL Overall)1786912278.14021952.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.