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

160 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
silicle93775(None) 
silicles1037071silicles
calicle113111432calicle
cilice103213352cilic_e
icicle1036582_icicle
sanicle91210262sanicle
silica8311242silic_a
silicas9310602silicas
silicate10312622silicate
silicic1147602silicic
silicide1147832silicide
silicon9117532silicon
silicone1096732silicone
silicula1065392silicula
siliculae1154282siliculae
silique1645642silique
simile83115632simi_le
slice74925822s_lic_e
splice104915102splic_e
alible8311973_alible
article9310923article
auricle9139813auricle
basilicae1343123basilicae
bicycle1643993bicycle
binocle1136493binocle
caliche14329953caliche
calicles123811433calicles
calycle14245833calycle
caulicle1245043caulicle
chicle134312543_chicle
ciliate9514603ciliate
cilices113814023cilices
circle1039703ci_rcle
cliche133712453_cliche
cubicle1337003cubicle
cuticle1138233cuticle
filial93013253filial_
filiate10414233filiate
filicide1446363filicide
fille84327403fil__le
follicle1344393follicle
funicle12237483funicle
icicled1234293_icicled
icicles1135943_icicles
ilial55317843_ilial_
lice66045063__lic_e
lisle53916723__lisle
malice104818483malic_e
mille75029133mil__le
miracle1138843miracle
mixible18195093mixible
oilhole1046263oilhole
oilily93111723oili_ly
ossicle944483ossicle
panicle11129983panicle
pedicle1238973pedicle
pellicle1245043pellicle
pilule8411123pil_ule
pinocle1138143pinocle
plicae10410953_plicae
police102918563polic_e
radicle103510713radicle
reticle94112623reticle
ridicule1144393ridicule
rille55728733ril__le
risible937923risible
saice75424053s_aic_e
sailable10310563sailable
salable91415463salable
salic73424713salic__
salicin9311223salicin
salicine10311703salicine
saline65132703sali_ne
sanicles10149943sanicles
scilicet1249543scilicet
sedile73517233sedi_le
seiche11811833s_eiche
selle54428313sel__le
senile63420213seni_le
seviche1545113seviche
sialic8313633sialic__
sice65545593s__ic_e
sickle124418323si_ckle
sidle65124033s__idle
sigil63515503sigi_l_
sigils73912363sigi_ls
silage72715303sil_age
silane62718053sil_ane
silence9310213silence
silicates11311523silicates
silicides1247073silicides
silicify1644273silicify
silicium1286563silicium
silicones11106553silicones
silicons10107163silicons
silicoses1186183silicoses
siliqua1643983siliqua
siliquae1743233siliquae
siliques1745353siliques
silkie103313403sil_kie
silkily14236963silkily
sill45545153sil__l_
siller64026063sil__ler
sillily10209783sillily
sills55135993sil__ls
silly84527623sil__ly
silvae92811093sil_vae
silvical1345223silvical
silvics1235563silvic_s
similes92915233simi_les
simple104315173si_mple
since75024173si_nc_e
single74520603si_ngle
sinicize1947333sinicize
sizable1839893sizable
sizzle14309613si_zzle
sliced94416313s_liced
slicer84117603s_licer
slices84022853s_lices
slick115520523s_lic_k
slicked144413843s_licked
slicken13309293s_licken
slicker133314533s_licker
slickly1635853s_lickly
slicks124816113s_licks
slide64725413s_li_de
slieve9359273s_lieve
slily85820033s_li_ly
slime74925753s_li_me
slimly11408903s_limly
slipe75626133s_li_pe
sluice849513sluic_e
smile74823923s_mi_le
socle7419573s__ocle
solace83415823solac_e
solicit9315743solicit
solidly1137353solidly
soluble966103soluble
spicae104313703s_picae
spice95528813s_pic_e
spicule11269933s_picule
spile75230083s_pi_le
spiracle1255803spiracle
spliced124310593spliced
splicer114710523splicer
splices113914383splices
spline86020533spli_ne
stickle132410973s_tickle
stifle93611903s_tifle
stile54931573s_ti_le
strickle1467793strickle
swiple11379233s_wiple
tunicle9308033tunicle
utricle937913utricle
vehicle15175253vehicle
vesicle12217923vesicle
virile9313433viri_le
visible1236923visible
wavicle1534063wavicle
wilily123310763wili_ly

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 Limit1340271606.26621389.6
3Display Results1601600.0602666.7
 (SQL Overall)1786911606.73226543.5
 
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.