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

399 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
scilla831094(None) 
scillas9310461scillas
ancilla948602ancilla
axilla13289572axilla
calla74827072_calla
cella75420312_cella
cilia73016762_cilia
scall74420372scall_
scalls84218202scalls
scull75315762scull_
sculls84613882sculls
shill85325332shill_
shills94519602shills
sigla64515202s_igla
sill45545152s_ill_
sills55135982s_ills
silly84527612s_illy
silva82714022s_ilva
skill94316722skill_
skills104313912skills
spill74821162spill_
spills84717452spills
squilla1635522squilla
stella63612972stella
still54922072still_
stills64118562stills
stilly93714072stilly
swill83417372swill_
swills94213352swills
villa85321232_villa
abolla8410193abolla
achillea1344103achillea
acicula11228133acicula
acidly125211793acidly
ancillae1047653ancillae
ancillas1048033ancillas
armilla936993armilla
ascidia1046673ascidia
axillae14248233axillae
axillar14247563axillar
axillas14278963axillas
bacillar1276533bacillar
bacilli1146393bacilli
barilla9310323barilla
bill67239933_bill_
bills75632863_bills
billy105525363_billy
brill74819953brill_
brillo84211003brillo
brills84916293brills
bulla74620563_bulla
call66838673_call_
callan83619603_callan
callas84526753_callas
calls75634733_calls
cedilla1036343cedilla
cell65031723_cell_
cellae84915933_cellae
cellar84514983_cellar
celli76717693_celli
cello74919583_cello
cells75428063_cells
challa114014193challa
chela103916803_chela
chill105619873chill_
chilli114312773chilli
chills114717703chills
chilly144113223chilly
chimla1337593chimla
chola104718033_chola
cholla113911023cholla
cicala10310053_cicala
circa9311403_circa
citola838393_citola
coala77521123_coala
cola66541393_c_ola
collar83816173_collar
colly104926773_colly
colza165112983_colza
cull65929643_cull_
cullay113910173_cullay
culls75425813_culls
cully105520463_cully
culpa93610963_culpa
dill55239973_dill_
dills65530973_dills
dilly94923783_dilly
drill64718263drill_
drills74414203drills
evilly1236593evilly
faille93414743faille
fella84918653_fella
fila74729133_fi_la
fill75540193_fill_
fille84327403_fille
fillo84319783_fillo
fills84632373_fills
filly114424903_filly
frill84917563frill_
frills94414223frills
frilly124111443frilly
gill56336183_gill_
gills64728193_gills
gilly94321633_gilly
gorilla836973gorilla
grill64617893grill_
grille74315743grille
grills74314803grills
hila76228353_hi_la
hill76439493_hill_
hillo84721653_hillo
hilloa94713033_hilloa
hills85431353_hills
hilly114422163_hilly
holla84918493_holla
icicle1036583icicle
icily101211683ici_ly
ilea45931463__ilea
ilia46026813__ilia
ilka87215153__ilka
ill37437093__ill_
ills47030423__ills
illy76925333__illy
jill116430263_jill_
jills125122823_jills
kibla1139833_kibla
kill85533173_kill_
kills94526173_kills
krill94213643krill_
krills104211283krills
latilla737953latilla
maill74420783maill_
maills84215283maills
manilla93012473manilla
maxilla16248193maxilla
megilla1036273megilla
micella11106823micella
milia72719563_milia
mill66541473_mill_
mille75029133_mille
mills75435053_mills
milpa92111403_milpa
mulla74317113_mulla
nill45634303_nill_
nills54926673_nills
ocellar936533ocellar
ocelli836843ocelli
olla44821173__olla
oscillate1145473oscillate
oscula837293osc_ula
paella8410913paella
papilla11127913papilla
perilla9311223perilla
pilea75123953_pilea
pill65339463_pill_
pillar8314023_pillar
pills74130973_pills
prill74117943prill_
prills84015613prills
psylla1133953psylla
quill148413763quill_
quillai1644993quillai
quills153811843quills
rachilla1345713rachilla
rill45140903_rill_
rille55728733_rille
rills55032713_rills
saiga64717933sai_ga
sail45447163sai_l_
sailed74327763sailed
sailer63526103sailer
sailor63113743sailor
sails55738103sai_ls
salal55425703s_alal
salina64221123salina
saliva93110743saliva
sall44544683s_all_
sally85129713s_ally
salpa75018353s_alpa
salsa56718923s_alsa
salsilla844023salsilla
scalar83612433scalar
scald84818123sc_ald
scalds94813693scalds
scale74629143sc_ale
scaled94822443scaled
scaler84321603scaler
scales84529313scales
scallop11237643scallop
scalp95217983sc_alp
scalps104315233scalps
scaly104718723sc_aly
scapula1136343scapula
scena74815783sc_ena
schema1388373schema
schiller13296473schiller
schlep1347093schlep
schlub1355003schlub
scholar1236943scholar
scholia1237823scholia
schul102510413schul_
schuln11256233schuln
schuls11299853schuls
schwa13426843sc_hwa
scintilla1153753scintilla
scion72214993sci_on
scions82612233scions
sclera838883sclera
scold85414863sc_old
scolds95011233scolds
scolex1538243scolex
scollop11275433scollop
scopula1154993scopula
scoria8513483scoria
scotia8310783scotia
scowl1012012973scowl_
scowls11549593scowls
scribal1137963scribal
scroll8310163scroll
scrolls938063scrolls
scrota8310183scrota
scuba94211593sc_uba
sculch13226213sculch
sculk115112463sc_ulk
sculks123610263sculks
sculled102911693sculled
sculler99812153sculler
sculp95314843sc_ulp
sculps104611753sculps
sculpt104412693sculpt
scuta75815753sc_uta
scutella1043543scutella
sedilia847243sedilia
sell45840613s_ell_
selle54428313s_elle
sells55134433s_ells
selva83014273s_elva
sensilla845623sensilla
shall85024053shall_
sheila969843sheila
shell84424123shell_
shellac1236693shellac
shells94319523shells
shelly124414463shelly
shelta93111783shelta
shiel811023773shiel_
shield106212973shield
shiels95418923shiels
shigella1243053shigella
shiksa1394653shiksa
shillala11143783shillala
shilled113313623shilled
shily115222013shi_ly
shiplap1444513shiplap
shiva115915003shi_va
shrill94712303shrill_
shrills10389933shrills
shrilly13318553shrilly
sial45938833s_ial_
sials54227243s_ials
sickle124418323sickle
sickly153110483sickly
sidle65124033s_idle
sigma84513823s_igma
signa66114703s_igna
sika86021323s_i_ka
sild55030583s_i_ld
silds65520523s_ilds
silex123417413s_ilex
silica8311243s_ilica
silk85529323s_i_lk
silks94620683s_ilks
silky125315823s_ilky
siller64026053s_iller
silo46037913s_i_lo
silos56029423s_ilos
silt46558193s_i_lt
silts55330823s_ilts
silty84721633s_ilty
silvae92811093s_ilvae
silvan92810153s_ilvan
silvas92912183s_ilvas
sima64730783s_i_ma
sirra54416323s_irra
sisal54217733s_isal
skell94915833skell_
skells105013783skells
skilled123110863skilled
skillet113512153skillet
skirl96012913skirl_
skirls10449823skirls
skull94812033skull_
skulls10429643skulls
slily85820033sli_ly
slimly11408903slimly
small74016263small_
smalls84514123smalls
smell74916233smell_
smells83914743smells
smelly114110353smelly
smilax1535393smilax
smile74823913smi_le
smiled93716433smiled
smiler83916683smiler
smiles84522293smiles
smiley114012303smiley
snell54517303snell_
snells64614203snells
social8813333social_
socially1338533socially
socials999633socials
soil46138823soi_l_
soiled73822473soiled
soils55327983soi_ls
sola45541863s__ola
spall74919303spall_
spalls84217343spalls
spell75020303spell_
spells84617683spells
spica94717943spi_ca
spicula11259293spicula
spiel74623913spiel_
spiels85317953spiels
spile75230083spi_le
spiled94621993spiled
spiles84227913spiles
spillage1146263spillage
spilled103613623spilled
spiller92914323spiller
spillway1642763spillway
spilt75532223spi_lt
spilth11469733spilth
spinal84915313spinal
spinula9257903spinula
spiral83715343spiral
spirea84015633spirea
spirilla1045063spirilla
spirula9257703spirula
spital83813873spital
squill1537223squill_
squillae1745183squillae
squillas1745323squillas
squills1666303squills
stall54722353stall_
stalls64019923stalls
stela54019043s_tela
stellar72610413stellar
stellas72813033stellas
stifle93611903stifle
stigma9226753stigma
stile54931573sti_le
stiles64328763stiles
stilled83314773stilled
stiller73414283stiller
stillman1043943stillman
stilt54831983sti_lt
stilts67915303stilts
stull54916273stull_
stulls63912973stulls
sulfa8313923s_ulfa
sully84622893s_ully
swell84815983swell_
swells93913983swells
swilled113611833swilled
swiller103211653swiller
swiple11379233swiple
swirl84514143swirl_
swirls94010133swirls
swirly12439243swirly
sylva11268443s_ylva
taille63116923taille
thill85918733thill_
thills95515383thills
till45941203_till_
tills54631703_tills
trill55122933trill_
trills64319853trills
tuille63012643tuille
twill85612723twill_
twills9489793twills
vanilla10238743vanilla
vexilla1744663vexilla
vill75235073_vill_
villae95615383_villae
villas96117263_villas
villi86517853_villi
vills86429323_vills
viola85915543_viola
voila84813943voi_la
walla85321033_walla
will75737513_will_
wills84528963_wills
willy115321913_willy
yill75628973_yill_
yills83921553_yills
zill135727613_zill_
zillah1836563_zillah
zills144020783_zills
zorilla1646023zorilla

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.1401276364.3
2DLD Change Limit1127163996.12618399.6
3Display Results3993990.1263166.7
 (SQL Overall)1786913996.39227955.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.