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

230 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
sylvin1224730(None) 
sylvan12257361sylvan
sylvine13216541sylvine
sylvins13246241sylvins
kelvin13117322kelvin
salvia93310752salvia
salving113913152salving
savin84625082s_avin
silvan92810152silvan
slain54923572s_lain
solving112910852solving
spavin114210652spavin
syli74318982syl_i_
sylis84316022syl_is
sylva11268442sylv_a
sylvae12236862sylvae
sylvans13235892sylvans
sylvas12288172sylvas
sylvines14215902sylvines
sylvite13266352sylvite
acyloin1247463acyloin
alevin92511513alevin
algin65718763_algin
aloin55227423_aloin
alvine94614583_alvine
ayin76331743ay__in
blain75421793_blain
blin67228173_bl_in
byline11311643byl_ine
calkin123515493calkin
calving134113503calving
colin76231693col_in
covin105621123_covin
cyanin113911453cyanin
cyclin1339273cyclin
cylix17448623cyl_ix
cymlin1337313cymlin
delving123711573delving
dynein1035563dynein
elain55324703_elain
elfin84312463_elfin
eloin55923203_eloin
flavin1239303flavin
glycin1235963glycin
gyving14415713gy_ving
halving143511543halving
helving144011133helving
hyalin122210043hyalin
kelvins14106563kelvins
kylix19416323kyl_ix
lain46146283__lain
levin84816413_levin
lin37967373__l_in
loin46838723__loin
lysin84512783ly_sin
malkin122913153malkin
mavin105722953_mavin
mayvin1436523mayvin
myelin1138973myelin
myosin113410763myosin
nylon82910513nyl_on
olein5316003_olein
pavin105623203_pavin
pelvic13307553pelvic
pelvis113610323pelvis
plain74823303_plain
psyllid1344523psyllid
pulvini1235073pulvini
pyin96823233py__in
pylon103614003pyl_on
ravin85624653_ravin
sabin74924953s_abin
saimin8313663saimin
sain45551293s__ain
salic73424713sal_ic
salicin9311223salicin
salina64221123sal_ina
saline65132703sal_ine
saliva93110743saliva
salmi7815863salmi_
salmis8514273salmis
salmon84614183salmon
salon55228553sal_on
saloon64418023saloon
salpian938493salpian
salpid9510883salpid
salpinx1636093salpinx
saltie63422433saltie
saltine75018563saltine
salting84120793salting
salve85022133salv_e
salved103916423salved
salver94617753salver
salves94221763salves
salvias10279933salvias
salvo84415643salv_o
salvoing1236423salvoing
salvor94711093salvor
salvos94613383salvos
sarin55239253s_arin
sasin54626573s_asin
satin55935223s_atin
savine94220283s_avine
saving104724513s_aving
savins93923133s_avins
sculpin11236653sculpin
seisin63715123seisin
seizin153610853seizin
selfing112911623selfing
selkie102811693selkie
selling83225833selling
selsyn983843selsyn
selva83014273selv_a
selvas93812913selvas
selves94119613selves
sequin1538523sequin
serein63318463serein
serin55434443s_erin
serving113014983serving
seven84118313s_even
shaven124213303shaven
shavie124312423shavie
shaving143414333shaving
shelving15278173shelving
shin75634313s__hin
shoving142910643shoving
sieving112311233sieving
sileni63312143sileni
silken104410853silken
silkie103313403silkie
silking123715593silking
siloing83215503siloing
silting83320483silting
silva82714023silv_a
silvae92811093silvae
silvans10308333silvans
silvas92912183silvas
silver93815813silver
silvern10347143silvern
silvex16336723silvex
silvics1235563silvics
simlin8311733simlin
sin36265893s___in
sirloin747593sirloin
siskin1079783siskin
skein94814413s_kein
skin85927533s__kin
skiving15298373skiving
skyline1436793skyl_ine
skylit1338283skyl_it
slaving113514833slaving
slid55828983s_l_id
slim66631963s_l_im
sling66028803s_l_ing
slink95422913s_l_ink
slip67031733s_l_ip
slit46250103s_l_it
sloid64619713s_loid
sloven9389633sloven
sluing74315883s_luing
solan55328153sol_an
solanin7311943solanin
soldan73511853soldan
soldi65717203soldi_
solei55624343solei_
solemn838643solemn
soli46637013sol_i_
solid65025083sol_id
soling74226823sol_ing
solion6616383solion
soloing82813803soloing
solon55026133sol_on
solve85618943solv_e
solved105312933solved
solvent10310833solvent
solver94016703solver
solves95018223solves
sozin14514543s_ozin
spavie113611383spavie
spavins12419323spavins
spin66231303s__pin
spleen8310263spleen
spline86020533spl_ine
splint85223283spl_int
split75729013spl_it
sprain83614863sprain
stain55727943s_tain
statin63921473statin
staving113915703staving
stein54620543s_tein
stotin63215063stotin
strain64919573strain
styli83911173styl_i_
styling112910653styl_ing
styloid1137553styloid
sulci7615053sulci_
suldan72611043suldan
sulfid1039063sulfid
sulking124514313sulking
sullen62914293sullen
sultan63012593sultan
swain84919053s_wain
sweven1235983sweven
swiving14358953swiving
sylph1347793syl_ph
sylphic1745883sylphic
sylphid1645963sylphid
sylphs1435543sylphs
sylphy1744153sylphy
sylvatic1645353sylvatic
sylvinite1542923sylvinite
sylvites14225843sylvites
symbion1464043symbion
syn67024123sy___n
syncing13177223syncing
syndic1237303syndic
synovia1345533synovia
syphon1436853syphon
syren85216743sy_ren
syrinx1637143sy_rinx
tyin76424003ty__in
tylosin1046903tylosin
valving14368553valving
welkin1337313welkin
wyling13368553wyl_ing
xylan1537463xyl_an
xylidin1844333xylidin
xyloid1738193xyloid
yin67648733_y__in
yogin98317743_yogin

Search took 6 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.376475242.0
2DLD Change Limit1127162305.48320557.4
3Display Results2302300.0802875.0
 (SQL Overall)1786912305.93930087.7
 
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.