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

103 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
silicons1010716(None) 
silicon9117531silicon_
silicone1096731silicone
silicones11106551silicones
helicons1337612helicons
salicins10310932salicins
silicas9310602silic_as
siliceous1145032siliceous
silicious1146432silicious
silicles1037072silicles
silicoses1186182silicoses
silicosis1164812silicosis
solions7513752soli_ons
solitons849592solitons
vidicons1443862vidicons
aglycons1442973aglycons
ailerons849853ailerons
allicins1049653allicins
bilious9310933bili_ous
billions102211793billions
billons93013363bil_lons
calicoes123911603calicoes
calicos113913493calico_s
cilices113814023cilic_es
colicins12312853colicins
dioicous1145133dioicous
falcons1239123fal_cons
flacons1238053_flacons
helicon1237643helicon_
icons76516493___icons
inions64417003_ini_ons
jillions15178283jillions
kilotons1286313kilotons
lexicons1743893lexicons
liaisons844293liaisons
limacons1243953limacons
lions55923213__li_ons
lyricons1343583lyricons
malisons1048783malisons
midirons1145883midirons
millions101712433millions
minions93314623mini_ons
mirlitons1144113mirlitons
oilcans936813oil_cans
pelicans1238093pelicans
pillions101610923pillions
pinions93413603pini_ons
psilocins1343563psilocins
replicons1344093replicons
sadirons936023sadirons
salicin9311223salicin_
salicine10311703salicine
salicines11310003salicines
salmons93713263sal_mons
salons63823693sal__ons
saloons74415323sal_oons
scions82612243s_ci_ons
sericins10312463sericins
sialidans1042973sialidans
silica8311243silic__a
silicate10312623silicate
silicates11311523silicates
silicic1147603silic_ic
silicide1147833silicide
silicides1247073silicides
silicify1644273silicify
silicium1286563silicium
siliciums1384633siliciums
silicle937753silic_le
silicotic1344303silicotic
silicotics1452773silicotics
silicula1065393silicula
siliques1745353siliques
siliquous1843053siliquous
silos56029433sil__o_s
silvans10308333sil_vans
silvics1235563silvic__s
simians959203simi_ans
simious939803simi_ous
simlins9311843simli__ns
simoons937943si_moons
siphons1239353si_phons
sitcoms1145533si_tcoms
slicers94114923s_licers
slices84022853s_lic_es
slicing103514643s_licing
slickens14317263s_lickens
slicks124816113s_lic_ks
solicits10311023solicits
solion6616383soli_on_
soliton7410233soliton_
solons65120023sol__ons
soupcons1244373soupcons
spilikins1543543spilikins
splicers12338113splicers
splices113914383splic_es
splicing1338963splicing
talions7314113tali_ons
vidicon1343783vidicon_
virions1039873viri_ons
visions10311023visi_ons
zillions17168073zillions
zircons1854963zi_rcons

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621037.00020880.3
3Display Results1031030.0303433.3
 (SQL Overall)1786911037.47023921.2
 
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.