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

232 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
siccan103759(None) 
wiccan1335031wiccan
oilcan837792oilcan
scan65530452s__can
sicced11489652sicced
siccing12319512siccing
sicken124615252sicken
silvan92810152silvan
simian8811162simian
socman1039812socman
succah1336642succah
wicca1247252wicca_
wiccans1434602wiccans
wiccas1336542wiccas
aidman92410623aidman
airman82414233airman
ashcan1135843ashcan
bacca111012183bacca_
baccae12119703baccae
bicorn103610103bicorn
bicron103710773bicron
buccal1248243buccal
can57760143___can
cancan10314103cancan
circa9311403circa_
clan65633923__clan
coccal9310223coccal
cyan96419623__cyan
desiccant1444193desiccant
dicta84915633dicta_
dioxan1465773dioxan
discant103017263discant
divan96114843di_van
diwan95712553di_wan
ficin103516723fi_cin
finca104714503finca_
fincas113512073fincas
firman112211353firman
fiscal1139333fiscal
glucan936183glucan
glycan1234903glycan
hiccup1554393hiccup
hitman112710223hitman
icecap1245223_icecap
iceman1037853_iceman
icon66922043_i_con
incant82418513_incant
lichen114012743lichen
ligan67920283li_gan
lignan75510323lignan
liman75921603li_man
lochan1139093lochan
mecca1139933mecca_
meccas1239493meccas
mica86428263mi_ca_
micas96823053mi_cas
micra96214973micra_
micron103714283micron
midcap1336473midcap
minyan1138173minyan
musician1246693musician
niacin8310223niacin
nicad8312613ni_cad
ocean71212963_ocean
ocicat101412813ocicat
octan71313483_octan
oilcans936813oilcans
oilman839483oilman
pecan91919033_pecan
peccant13311733peccant
pechan13511543pechan
pian66136103pi__an
pica85831503pi_ca_
pical95524373pi_cal
picas94626523pi_cas
piccata1345703piccata
pickax2135913pickax
pitman102412123pitman
richen113812513richen
ricin74620213ri_cin
ricrac1037013ricrac
rictal83113193rictal
saccade12107033saccade
saccate111311763saccate
sacra74516993sacra_
sacral83414413sacral
sampan102511893sampan
saran53730313s_aran
scab85926713s__cab
scad75725773s__cad
scag76626893s__cag
scam85932353s__cam
scans74625103s__cans
scant79735073s__cant
scar66434203s__car
scat65848373s__cat
scena74815783s_cena
schav1338313s_chav
scion72214993s_cion
scorn75817453s_corn
scrag85916173s_crag
scram910621623s_cram
scrap97120403s_crap
seaman84015903seaman
seawan94111223seawan
secant84023293s_ecant
secco9312423secc_o
seccos1039923seccos
secern81010223secern
secpar1037933secpar
sedan65620423s_edan
seitan62613233seitan
sewan85921293s_ewan
sextan13389643sextan
shaman113314283shaman
shipman14247133shipman
shoran94016043shoran
sial45938843si__al
siamang1045333siamang
sic55847883si_c__
sice65545603si_c_e
sices75637273si_ces
sick106435583si_c_k
sickbay1843723sickbay
sicked134524403sicked
sickee124622223sickee
sickens134411483sickens
sicker124023903sicker
sickie123715743sickie
sicking143720173sicking
sickle124418323sickle
sickly153110483sickly
sicko115315393si_cko
sickos125112033sickos
sicks115127623si_cks
sics65234103si_c_s
sidecar1045233sidecar
sideman1037973sideman
sienna647193sienna
sierran737193sierran
sigla64515203sigla_
sigma84513833sigma_
sigmas94111363sigmas
sign55523063si__gn
signa66114703signa_
signal73711483signal
sika86021333si_ka_
sikas94617023si_kas
silane62718053si_lane
silica8311243silica_
silicas9310603silicas
silicon9117533silicon
silken104410853silken
silva82714023silva_
silvae92811093silvae
silvans10308333silvans
silvas92912183silvas
sima64730793si_ma_
simar74920813si_mar
simas75727553si_mas
simians959203simians
simlin8311733simlin
simoon858063simoon
sin36265903si___n
since75024173sinc_e
siphon1138463siphon
sirdar7269103sirdar
siren54525823si_ren
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
sisal54217733si_sal
siskin1079783siskin
sitar54820543si_tar
sitcom1036903sitcom
sitten64113823sitten
sizar145214993si_zar
skean94415623s_kean
skycap1742913skycap
skyman1535313skyman
slicken13309293slicken
slogan7539223slogan
soca66330053s_oca_
socas74026183s_ocas
soccage1236283soccage
soccer1038543soccer
social8813333social
sockman1535663sockman
socmen1039193socmen
solan55328153s_olan
soldan73511853soldan
soman75024903s_oman
soucar839323soucar
soudan73210353soudan
sovran937153sovran
sowcar1135863sowcar
span65234663s__pan
spean74620513s_pean
spica94717943spica_
spicae104313703spicae
spicas104715823spicas
spiccato1463183spiccato
stickman1643943stickman
subclan1147183subclan
succahs1435333succahs
succor1036623succor
sulcal8311283sulcal
suldan72611043suldan
sultan63012593sultan
suntan62613003suntan
swan76631313s__wan
sylvan12257363sylvan
tical76021493ti_cal
ticced11438443ticced
ticcing12308633ticcing
tictac1036563tictac
tincal83913373tincal
tinman82411143tinman
tipcat10312653tipcat
titan53318173ti_tan
titian62512663titian
titman82711003titman
toucan838193toucan
vicar10513863vi_car
vicuna11115903vicuna
vinca105315163vinca_
vincas113912453vincas
wigan95114393wi_gan
witan83816503wi_tan
yucca12467443yucca_
yuccas13426553yuccas
zircon1754953zircon

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 Filter1786911127160.390458182.1
2DLD Change Limit1127162325.79619447.2
3Display Results2322320.0802900.0
 (SQL Overall)1786912326.26628517.6
 
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.