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

181 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
sylvine1321654(None) 
sylvin12247301sylvin_
sylvines14215901sylvines
sylvins13246241sylvins
sylvite13266351sylvite
alvine94614582_alvine
byline11311642byl_ine
saline65132702sal_ine
saltine75018562saltine
salving113913152salving
savine94220282s_avine
skyline1436792skyl_ine
solving112910852solving
spline86020532spl_ine
sylvae12236862sylv_ae
sylvan12257362sylvan_
sylvans13235892sylvans
sylvinite1542922sylvinite
sylvites14225842sylvites
aline57243153_al_ine
alkine104916803_alkine
alpine84417373_alpine
bovine11712433_bovine
bylined1335853byl_ined
byliner1235723byl_iner
bylines1239243byl_ines
calcine11315273calcine
calving134113503calving
cervine122610803cervine
cline76428533_cl_ine
corvine122113643corvine
cyanine122911513cyanine
cystine1239333cystine
delaine8314793delaine
delving123711573delving
divine103514463_divine
feline94820143fel_ine
flavine1338453flavine
fulmine1257963fulmine
glycine1335713glycine
guyline11258173guyl_ine
gyving14415713gy_ving
halving143511543halving
helving144011133helving
hyaline132310723hyaline
hyenine1336953hyenine
isoline7314013isol_ine
kelvin13117323kelvin_
kelvins14106563kelvins
line46965583__l_ine
lysine94210553ly_sine
maline84529093mal_ine
milline92519113milline
moline84422033mol_ine
myeline1238253myeline
nervine102510633nervine
oleine6313793_oleine
olivine1038843olivine
online6315843onl_ine
ovine86316643__ovine
pulvini1235073pulvini
ralline73518413ralline
ravine95522223_ravine
reline65434353rel_ine
sabine84020393s_abine
salicine10311703salicine
salina64221123sal_ina
salines74029413sal_ines
salpinx1636093salpinx
saltie63422433salti_e
saltines82917793saltines
salting84120793salting
saltire73113043saltire
salvage1138193salvage
salve85022133salv__e
salvia93310753salvi_a
salvias10279933salvias
salvoing1236423salvoing
sardine83317393sardine
savin84625083s_avin_
savines104417633s_avines
saving104724513s_aving
savins93923133s_avins
seine55732873s__eine
selfing112911623selfing
selkie102811693selki_e
selling83225833selling
selvage1136553selvage
serine65432673s_erine
service1239093service
servile10310643servile
serving113014983serving
sestine73017923sestine
setline7313923setline
shavie124312423shavi_e
shaving143414333shaving
shelving15278173shelving
shine85533093s__hine
shoving142910643shoving
shrine94920053s_hrine
sibylline1442893sibylline
sieving112311233sieving
silane62718053sil_ane
silkie103313403silki_e
silking123715593silking
siloing83215503siloing
silting83320483silting
silvae92811093silv_ae
silvan92810153silvan_
silvans10308333silvans
silvics1235563silvics
sine46560633s___ine
skiving15298373skiving
skylike1336103skyl_ike
skylines1535703skyl_ines
slain54923573s_lain_
slainte738543s_lainte
slaving113514833slaving
slice74925823s_l_ice
slide64725423s_l_ide
slime74925753s_l_ime
sling66028803s_l_ing
slink95422913s_l_ink
slipe75626133s_l_ipe
sluice849513s_luice
sluing74315883s_luing
smaltine1037833smaltine
solanine8311533solanine
soling74226823sol_ing
soloing82813803soloing
solvate102710213solvate
solve85618943solv__e
solvent10310833solvent
sordine82515233sordine
sozine15712353s_ozine
spavie113611383spavi_e
spavin114210653spavin_
spavined1434333spavined
spavins12419323spavins
spine76534423s__pine
splice104915103spl_ice
splined105013113spl_ined
splines94718893spl_ines
splint85223283spl_int
stanine73417073stanine
staving113915703staving
stibine938663stibine
styling112910653styl_ing
stylise10208953styl_ise
stylite10219613styl_ite
stylize19177453styl_ize
subline9316893subline
subvene1238493subvene
sulfide1138103sulfide
sulfite10310473sulfite
sulfone1037483sulfone
sulking124514313sulking
supine84216693s_upine
survive1335933survive
swine85625303s__wine
swiving14358953swiving
sycamine1545723sycamine
syenite1039773syenite
syli74318983syl_i__
sylis84316023syl_i_s
sylva11268443sylv__a
sylvanite1543793sylvanite
sylvas12288173sylv_as
sylvinites1642653sylvinites
syncing13177223syncing
syncline1356073syncline
syne75725763sy___ne
syringe11349473sy_ringe
syrinx1637143sy_rinx
valine94623093val_ine
valving14368553valving
vine75643693___vine
vulpine1235903vulpine
wyling13368553wyl_ing
xylene1645793xyl_ene
xylidine1943753xylidine

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.420425454.8
2DLD Change Limit1340271816.58020368.8
3Display Results1811810.0762381.6
 (SQL Overall)1786911817.07625253.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.