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

132 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
sylvite1326635(None) 
sylvine13216541sylvine
sylvites14225841sylvites
solvate102710212solvate
stylite10219612styl_ite
sulfite10310472sulfite
syenite1039772syenite
sylvae12236862sylv_ae
sylvanite1543792sylvanite
sylvin12247302sylvi_n
sylvines14215902sylvines
sylvinite1542922sylvinite
sylvins13246242sylvins
albite8313313_albite
alvine94614583_alvine
aplite8316393apl_ite
blite76225353_bl_ite
byline11311643byl_ine
calcite11413783calcite
cyanite122710763cyanite
elite56230183_el_ite
evite85317683__evite
felsite1039083felsite
flite85424963_fl_ite
halite93624233hal_ite
hyalite13229473hyalite
illite63414923_illite
invite93715033_invite
iolite63221983iol_ite
kyanite14237313kyanite
lite47054543__l_ite
lyddite1243333lyddite
mullite9313013mullite
mylonite1346823mylonite
oolite63319603ool_ite
pelite84323003pel_ite
phyllite1645743phyllite
polite83625073pol_ite
pyrite11913313py_rite
saline65132703sal_ine
salivate11310013salivate
saltie63422433salti_e
saltine75018563saltine
saltire73113033saltire
salute64418023sal_ute
salvage1138193salvage
salve85022133salv__e
salvia93310753salvi_a
salvias10279933salvias
salving113913153salving
samite83020603s_amite
savate9313783s_avate
savine94220283s_avine
sclerite10410713sclerite
selenite81713113selenite
selkie102811693selki_e
selvage1136553selvage
service1239093service
servile10310643servile
shavie124312423shavi_e
shiviti1344863shiviti
sienite7312713sienite
silkie103313403silki_e
silvae92811093silv_ae
silvics1235563silvics
site47052413s___ite
skite95120053s__kite
skylike1336103skyl_ike
skyline1436793skyl_ine
skylit1338283skyl_it_
skywrite1842923skywrite
slainte738543s_lainte
slate55438283s_l_ate
slice74925823s_l_ice
slide64725413s_l_ide
slime74925753s_l_ime
slipe75626133s_l_ipe
slit46250103s_l_it_
slits56128853s_l_its
sluice849513s_luice
smaltite1046903smaltite
smite75224873s__mite
solate64526073sol_ate
solute64016663sol_ute
solvated12237443solvated
solvates11249673solvates
solve85618943solv__e
solving112910853solving
somite84519373s_omite
sopite84917713s_opite
soviet9720153s_oviet
spavie113611383spavi_e
spaviet123011923spaviet
spite75430663s__pite
splice104915103spl_ice
spline86020533spl_ine
split75729013spl_it_
splits85416413spl_its
sprite84421773s_prite
stellite839533stellite
stilbite1045423stilbite
stylate10179773styl_ate
stylise10208953styl_ise
stylites11168693styl_ites
stylize19177453styl_ize
stylolite1244383stylolite
suavity1336313suavity
subsite9412873subsite
suite54829563s__uite
sulcate9314423sulcate
sulfate10311653sulfate
sulfide1138103sulfide
sulfites1139903sulfites
sulphite1346003sulphite
survive1335933survive
sybarite1396543sybarite
syenites1138943syenites
syli74318983syl_i__
sylis84316023syl_i_s
sylva11268443sylv__a
sylvan12257363sylv_an
sylvanites1643283sylvanites
sylvans13235893sylvans
sylvas12288173sylv_as
sylvatic1645353sylvatic
sylvinites1642653sylvinites
symbiote1563233symbiote
syrette1037183syrette
tillite7313563tillite
valvate133710813valvate
volvate13317993volvate
vulvate13388323vulvate

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.406440125.6
2DLD Change Limit1340271326.39320964.6
3Display Results1321320.0462869.6
 (SQL Overall)1786911326.84526105.3
 
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.