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

498 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
silkie10331340(None) 
selkie102811691selkie
sickie123715741sickie
silkier114411641silkier
silkies113715691silkies
alkie95520032_alkie
bikie113915882bi_kie
billie85019172billie
birkie124110132birkie
dickie133913112dickie
folkie13369612folkie
gillie74816942gillie
hickie153812472hickie
killie104114892killie
kiltie103210962kiltie
milkier133411162milkier
pinkie124414272pinkie
saltie63422432saltie
selkies113513352selkies
sickee124622222sickee
sickies133717502sickies
sickle124418322sickle
sike87138782si_k_e
silage72715302silage
silane62718052silane
silk85529322silk__
silked114314812silked
silken104410852silken
silkiest123212852silkiest
silkily14236962silkily
silking123715592silking
silklike1135522silklike
silks94620682silk_s
silky125315822silk_y
sillier74017592sillier
sillies73425082sillies
siltier73413862siltier
silvae92811092silvae
siskin1079782siskin
sulkier113811962sulkier
sulkies114315762sulkies
talkie103914442talkie
willie94116452willie
airlike11310333airlike
alike95523963alik_e
alkies104518093_alkies
alkine104916803_alkine
asslike1137373asslike
axlike17388853axlike
bailie83818363bail_ie
balkier134111983balkier
belie75630383bel_ie
belike124616283belike
biblike1536893biblike
biggie103810933biggie
bike106532603bi_k_e
bikies124515163bi_kies
bilbies114712343bilbies
bile66147183bil__e
bilge87618913bil_ge
bilgier10358533bilgier
bilk105824423bilk__
bilked134012943bilked
bilker124913443bilker
bilking144413553bilking
bilks115117893bilk_s
billies93923503billies
birdie94013783birdie
birkies133712433birkies
bookie123516003bookie
bulkier134111513bulkier
calkin123515493calkin
cilia73016763cil_ia
cilice103213353cilice
civie103716353ci_vie
collie83621993collie
cookie123716043cookie
darkie113714013darkie
dickier143512453dickier
dickies143416343dickies
didie74120563di_die
dike95935763di_k_e
dilate73220693dilate
dildoe8198673dildoe
dillies84122163dillies
dilute72911803dilute
dinkier123411503dinkier
dinkies123716033dinkies
dislike122913453dislike
duckie133511663duckie
falsie93513853falsie
fickle153912973fickle
file75446643fil__e
fille84327403fil_le
fillies103420253fillies
fillip11268953fillip
filmi105914003filmi_
filmic13348453filmic
filmier1237503filmier
filmis114610283filmis
filose96112503filose
finlike14279063finlike
firkin1337823firkin
folkier14359043folkier
folkies143612253folkies
ghillie11326353ghillie
gillied95512313gillied
gillies84120963gillies
gimmie11298183gimmie
girlie73711463girlie
hackie154615623hackie
hankie133915713hankie
hawkie163810093hawkie
hickies163614743hickies
hike116830393hi_k_e
hili75626633hil_i_
hillier103413963hillier
hinkier143610793hinkier
hiplike1637603hiplike
hippie132811243hippie
honkie133011673honkie
hulkier14328973hulkier
hunkie133812383hunkie
ickier12439923_ickier
ilia46026823_il_ia
ilk78325303_ilk__
ilka87215153_ilk_a
ilks87218573_ilk_s
illite63414923_illite
indie63721473_indie
inkier104013783_inkier
inkle94515833_inkle
isle45121703isl__e
jiglike19105333jiglike
jimmie17376473jimmie
junkie17339603junkie
kelpie12308613kelpie
kickier12349053kickier
kiddie12359393kiddie
kidlike1137063kidlike
kike76524793ki_k_e
kilim11711893kil_im
killies113318113killies
kilties113014143kilties
kinkier10319433kinkier
kookie9389843kookie
lie38264523__l_ie
like86040843li_k_e
lilied73913213lil_ied
lilies63021413lil_ies
liplike1337283liplike
luckie123611413luckie
malkin122913153malkin
mickle143715133mickle
mike105535293mi_k_e
milage93414123milage
mile66352573mil__e
milia72719573mil_ia
milieu8314113mil_ieu
milk105028473milk__
milked134612573milked
milker124814323milker
milkiest142911083milkiest
milkily16216553milkily
milking143712763milking
milkmen1565213milkmen
milks115020583milk_s
milky144014443milk_y
mille75029133mil_le
millier93716703millier
millime112511403millime
milline92519113milline
miltier93214963miltier
minke115421763mink_e
mirkier13319053mirkier
mislie83219153mislie
mislike132914833mislike
mollie83517103mollie
muskie123412543muskie
nellie63614813nellie
niblike1336703niblike
nickle123814483nickle
nixie125114943ni_xie
nookie103712433nookie
oilier64417233oil_ier
oilskin1144473oilskin
oldie6415473_oldie
oxlike17307473oxlike
pickier153912973pickier
pickle144215653pickle
piggie103210773piggie
piglike14157313piglike
pike106335213pi_k_e
piki106520563pi_ki_
pikis115116393pi_kis
pile65649693pil__e
pilei74021783pilei_
pili66130353pil_i_
pilis75825203pil_is
pilose84514243pilose
pilule8411123pilule
pinkies133818263pinkies
pipkin14248603pipkin
pixie145415523pi_xie
plie65127393_pl_ie
pliskie1394543pliskie
punkie123513613punkie
quickie2235513quickie
riblike1337333riblike
rile45650533ril__e
rille55728733ril_le
riskier1138423riskier
rookie103613263rookie
saclike131210123saclike
sake85244963s_ak_e
saki85628483s_aki_
sakis95323673s_akis
sale44959703sal__e
salic73424713sal_ic
saline65132703saline
sallied83316953sallied
sallier73320423sallier
sallies73227813sallies
salmi7815863salmi_
salmis8514273salmis
salpae84614273salpae
salpid9510883salpid
saltier74318633saltier
salties73725773salties
saltine75018563saltine
saltire73113043saltire
saluki1036203saluki_
salukis1136033salukis
salute64418023salute
salve85022133sal_ve
salvia93310753salvia
sarkier113413313sarkier
sawlike14138443sawlike
selle54428313sel_le
shake124726403shak_e
shakier143411153shakier
shavie124312423shavie
sheltie10109913sheltie
shikse1386073shikse
shilpit1247103shilpit
shrike134513243shrike
sialic8313633sialic
sialid7314943sialid
sialoid8310963sialoid
sice65545593si__ce
sick106435573sick__
sickbed16396823sickbed
sicked134524403sicked
sickees134514213sickees
sicken124615253sicken
sicker124023903sicker
sicking143720173sicking
sickish1638423sickish
sickled144713433sickled
sickles133417543sickles
sicklied1546583sicklied
sicklier1457213sicklier
sicklies14710013sicklies
sickly153110483sickly
sicko115315393sick_o
sickos125112033sickos
sicks115127623sick_s
side55444493si__de
sidhe95315103si_dhe
sidle65124033si_dle
siege66718443si_ege
sienite7312713sienite
sieve84918843si_eve
sighlike1635533sighlike
sigil63515503si_gil
sigloi737743sigloi_
signee73617233signee
sika86021323si_k_a
sikas94617023si_kas
siker95326033si_ker
sikes96236083si_kes
silages82514443silages
silanes72517163silanes
sild55030583sil__d
silds65520523sil_ds
silence9310213silence
sileni63312143sileni
silent64125843silent
silesia739083silesia
silex123417413sil_ex
silexes1438653silexes
silica8311243silica
silicic1147603silicic
silicide1147833silicide
silicle937753silicle
silique1645643silique
silkaline1344243silkaline
silkiness1337253silkiness
silkoline1343653silkoline
silkweed1643223silkweed
sill45545153sil__l
siller64026063siller
silliest84017103silliest
sillily10209783sillily
sills55135993sil_ls
silly84527623sil_ly
silo46037913sil__o
siloed74615303siloed
siloing83215503siloing
silos56029433sil_os
silt46558193sil__t
silted74020013silted
siltiest83515613siltiest
silting83320483silting
silts55330823sil_ts
silty84721633sil_ty
silurid837013silurid
silva82714023sil_va
silvan92810153silvan
silvas92912183silvas
silver93815813silver
silvex16336723silvex
silvics1235563silvics
simile83115633simile
simlin8311733simlin
simple104315173simple
since75024173si_nce
sine46560623si__ne
singe65731133si_nge
single74520603single
sink86640143sink__
sinkage1287263sinkage
sinker103620903sinker
sinking123320543sinking
sinks95529183sink_s
sinopie948783sinopie
sipe67341043si__pe
sire46150413si__re
siree55238813si_ree
sirloin747593sirloin
sirree64017343sirree
siskins1159583siskins
sissier73711363sissier
sissies73716603sissies
site47052413si__te
sixte126216583si_xte
sixties14310973sixties
size135630963si__ze
sizier1514813393si_zier
sizzle14309613sizzle
skee85431473s__kee
ski74925693s__ki_
skid95720933s__kid
skied104417753s__kied
skier95119593s__kier
skies95026833s__kies
skiey125012893s__kiey
skim105322513s__kim
skin85927533s__kin
skinlike1134873skinlike
skip105421753s__kip
skis84825293s__kis
skit85437533s__kit
skite95120053s__kite
skive124614113s__kive
skylike1336103skylike
slain54923573s_lain
slake93724053s_lake
slate55438283s_late
slave84224033s_lave
slice74925823s_lice
slid55828983s_l_id
slide64725413s_lide
slier54827243s_l_ier
slieve9359273slieve
slim66631963s_l_im
slime74925753s_lime
slimier93212013slimier
slinkier12206933slinkier
slip67031733s_l_ip
slipe75626133s_lipe
slit46250103s_l_it
slitlike1235303slitlike
sloe45534953s_l_oe
sloid64619713s_loid
slope75823563s_lope
slue45332193s_l_ue
sluice849513s_luice
slype105112363s_lype
smile74823923smil__e
smirkier1444433smirkier
smoke115015823smok_e
smokier1356703smokier
snake94821113snak_e
snakier112810003snakier
softie93312483softie
soilage8169353soilage
soilure736233soilure
soke85436263s_ok_e
solace83415823solace
solate64526073solate
soldi65717203soldi_
soldier82812153soldier
sole46053673sol__e
solei55624343solei_
soli46637013sol_i_
solid65025083sol_id
solute64016663solute
solve85618943sol_ve
sonlike112110713sonlike
sonsie6614863sonsie
sortie63621993sortie
spake114322743spak_e
spavie113611383spavie
specie10412223specie
spike114922843spik_e
spikier13369983spikier
spile75230083spil__e
spilikin1443763spilikin
splake1259783splake
splice104915103splice
spline86020533spline
split75729013spl_it
splore81611303splore
spoke114818663spok_e
spunkie13215303spunkie
stake95927533stak_e
stalkier1257073stalkier
stickier14229763stickier
stickies142211973stickies
stickit1339463stickit
stickle132410973stickle
stiffie13245773stiffie
stilbite1045423stilbite
stile54931573stil__e
stillier868823stillier
stinkier12278543stinkier
stogie7311323stogie
stoke94922513stok_e
strike105619733strike
stymie1137623stymie
suckier133613973suckier
suckle124015963suckle
suitlike1236313suitlike
sulci7615053sulci_
sulfid1039063sulfid
sulfide1138103sulfide
sulfite10310473sulfite
sulk85326653sulk__
sulked114314703sulked
sulker104015923sulker
sulkiest124212503sulkiest
sulkily14218113sulkily
sulking124514313sulking
sulks94818463sulk_s
sulky124715363sulk_y
sullied83714483sullied
sullies74122233sullies
sunlike112310573sunlike
syke115420563s_yk_e
syli74318983syl_i_
sylis84316023syl_is
sylvae12236863sylvae
sylvin12247303sylvin
sylvine13216543sylvine
sylvite13266353sylvite
talkier114011843talkier
talkies113415733talkies
tekkie934203tekkie
tickle124616743tickle
tike85534483ti_k_e
tiki87620843ti_ki_
tikis95615973ti_kis
tilde65017343til_de
tile45451443til__e
tillite7313563tillite
tinkle103714453tinkle
tinlike11248803tinlike
tittie63213153tittie
trickie132611033trickie
twinkie1434573twinkie
unlike102614063unlike
vile76139803vil__e
villae95615383villae
villi86517853villi_
wallie93216803wallie
welkin1337313welkin
wellie92814913wellie
widdie113410733widdie
wienie9229973wienie
wiglike15125853wiglike
wile75944373wil__e
wilier93217073wil_ier
willied114611563willied
willies103920153willies
winkle133812833winkle
yippie13277843yippie
yolkier14336123yolkier

Search took 6 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.373479064.3
2DLD Change Limit1127164985.31321215.1
3Display Results4984980.1732878.6
 (SQL Overall)1786914985.85930498.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.