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

421 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
sheila96984(None) 
sheilas1059401sheilas
chela103916802che_la
heil76328932_heil_
heils85222192_heils
hila76228352_h_ila
shea76031572she__a
sheal84927702sheal_
sheals94420642sheals
sheik122514652shei_k
sheikh16206992sheikh
sheiks132510012sheiks
sheitan1036562sheitan
shelf115221112she_lf
shell84424122she_ll
shellac1236692shellac
shells94319522shells
shelly124414462shelly
shelta93111782shelta
sheol84318362sheol_
sheols94614152sheols
sherpa1138092sherpa
shiel811023772shiel_
shield106212972shield
shiels95418922shiels
shill85325332sh_ill
shily115222012sh_ily
shiva115915002sh_iva
shrill94712302shrill
speil75618642speil_
speils84116222speils
stela54019042ste_la
stella63612972stella
abelia83114403abelia
akela9311343ake_la
aphelia1249423aphelia
areola6813673areola
ceiba938703_ceiba
ceil65725063_ceil_
ceili75814793_ceili
ceils75019403_ceils
cella75420313_cella
challa114014193challa
chelae113614603che_lae
chelas113817203che_las
chia96026623ch_i_a
chica125818263ch_ica
chiel104918973chiel_
chield124610213chield
chiels115115933chiels
child114516223ch_ild
chile105626893ch_ile
chili106218483ch_ili
chill105619873ch_ill
chimla1337593chimla
china105022483ch_ina
chola104718033ch_ola
cholla113911023cholla
deil56231623_deil_
deils65722863_deils
fella84918653_fella
fila74729133__fila
haika125313793_haika
hail74839063_hail_
hails85231643_hails
heal75645693_heal_
heals85733453_heals
heel75034223_heel_
heels85625533_heels
hegira1036523_hegira
heigh124812543_heigh
heiled104415613_heiled
heir77523803_hei_r
heirs85618563_heirs
heist87030913_heist
hejira1644803_hejira
held85330403_he_ld
heliac111010893_heliac
helio85321193_helio
helix154413013_helix
hell75637893_he_ll
hello86522983_hello
hells85032043_hells
helm95530023_he_lm
helo75332853_he_lo
help95328923_he_lp
hemal104419803_hemal
hemiola12107003_hemiola
henna84414043_henna
herl75834553_herl_
herls85226433_herls
herma105318883_herma
hilar85418143_h_ilar
hili75626633_h_ili
hill76439493_h_ill
hilt75850713_h_ilt
holla84918493_holla
hula74923753_h_ula
hyla106716513_h_yla
kheda1346533khe_da
manila84518303manila
obelia8329453obelia
ohia75719363oh_i_a
paella8410913paella
pepla9312863_pepla
phial10313203ph_ial
phyla13469183ph_yla
rhea75017433rhe__a
saiga64717933s_aiga
sail45447163s_ail_
sails55738103s_ails
salina64221123salina
saliva93110743saliva
scena74815783sce_na
schema1388373sche_ma
scholia1237823scholia
scilla8310943scilla
sea36161293s_e__a
seal45654373s_eal_
seals54839693s_eals
sedile73517233sedile
sedilia847243sedilia
seedily1178583seedily
seeing74222143seeing
seel45042983s_eel_
seels55632823s_eels
seely84522633s_eely
seemly1138433seemly
sei36048933s_ei__
seif75638733s_ei_f
seifs85019333s_eifs
seine55732873s_eine
seis45542393s_ei_s
seise54727853s_eise
seism75019023s_eism
seitan62613233s_eitan
seize143819503s_eize
sel38253323s_e_l_
selah8319613s_e_lah
self75138293s_e_lf
sell45840613s_e_ll
selle54428313s_elle
sells55134433s_ells
sels46345983s_e_ls
selva83014273s_elva
semina8915563semina
senile63420213senile
senna54617983s_enna
sensa54117473s_ensa
sepal77723003s_epal
sepia75318673s_epia
septa75518083s_epta
sera46141393s_e_ra
seral56336383s_eral
serial64625853serial
seta45637313s_e_ta
setal56430903s_etal
sexily1638853sexily
sha69837783sh___a
shadily1437723shadily
shaird10288703shaird
shairn9269063shairn
shaitan1036883shaitan
shakily1736903shakily
shale85332833sh_ale
shall85024053sh_all
shalt85534483sh_alt
shaly114322863sh_aly
sharia93116723sharia
shaul85418103shaul_
shauls94913113shauls
shawl116217573shawl_
shawls125411973shawls
she66837693she___
sheaf115424123she_af
sheafs124912883sheafs
shear85424833she_ar
shears93820903shears
sheas86331793she_as
sheath12412883sheath
sheave124514003sheave
shebean1235763shebean
shed86536153she__d
sheds96122703she_ds
sheen85023313she_en
sheens95116993sheens
sheeny124912193sheeny
sheep105321523she_ep
sheer84726893she_er
sheerly13337703sheerly
sheers94322403sheers
sheesh1237813sheesh
sheet84836953she_et
sheets93918493sheets
sheeve123412843sheeve
sheikhs17233993sheikhs
sheitans1155593sheitans
shekel1338383shekel
shekels1436043shekels
shellack1745083shellack
shellacs1345573shellacs
shelled113815083shelled
sheller103515883sheller
sheltas10279663sheltas
shelty124011543shelty
shelve124012763shelve
shelvy15377863shelvy
shend94719973she_nd
shends105313773shends
shent85933493she_nt
sheqel1846523sheqel
sheqels1934753sheqels
sherd96321153she_rd
sherds105614723sherds
sherif122915233sherif
sheriff16287693sheriff
sherifs13299683sherifs
sherpas1238093sherpas
sherry124510413sherry
shes75734353she__s
shetland1244633shetland
sheuch14267043sheuch
sheugh13295883sheugh
shew108030763she__w
shewed134716183shewed
shewer124515103shewer
shewing143812193shewing
shewn115715703she_wn
shews115924713she_ws
shibah14387473sh_ibah
shied96125493sh_ied
shields11538043shields
shier85428943sh_ier
shiers94921753shiers
shies86136553sh_ies
shiest95821523shiest
shift114225133sh_ift
shigella1243053shigella
shikar1336803sh_ikar
shiksa1394653shiksa
shills94519613shills
shim95827853sh_i_m
shims104422543sh_ims
shin75634303sh_i_n
shine85533093sh_ine
shinily13268933shinily
shins85131043sh_ins
shiny115122143sh_iny
ship95228233sh_i_p
shiplap1444513shiplap
ships105123773sh_ips
shire84727133sh_ire
shirk124817843sh_irk
shirr84716923sh_irr
shirt84533893sh_irt
shist84829603sh_ist
shit76745933sh_i_t
shits84731163sh_its
shiv105721163sh_i_v
shivah15488543sh_ivah
shivas124512413sh_ivas
shive114423423sh_ive
shivs115018803sh_ivs
shoal83920263shoal_
shoals94215783shoals
shoaly124010763shoaly
shoebill1344203shoebill
shoeing113211873shoeing
shool84523143shool_
shools94919003shools
shorl84720243shorl_
shorls94516193shorls
should1038023should
showily1636213showily
shri76021693shri__
shriek134211103shriek
shrift12413543shrift
shrike134513243shrike
shrills10389933shrills
shrilly13318553shrilly
shrimp13478763shrimp
shrine94920053shrine
shrink134511733shrink
shris84221443shri_s
shrive125216953shrive
shtetl936433shtetl_
shtetls1034573shtetls
shtick15308013shtick
shtik123210953shti_k
shtiks13297823shtiks
shul75823153sh_ul_
shuln84713113sh_uln
shuls85319713sh_uls
shwa106014963sh__wa
shying134211843shying
shyly144811573sh_yly
sial45938833s__ial
sienna647193sienna
sierra637313sierra
siesta639503siesta
sigil63515503sigil_
sigils73912363sigils
sigla64515203s_igla
sika86021323s__ika
sild55030583s__ild
silica8311243silica
silk85529323s__ilk
sill45545153s__ill
silo46037913s__ilo
silt46558193s__ilt
silva82714023s__ilva
sima64730783s__ima
similar937853similar
simile83115633simile
skeigh14265903skeigh
skein94814403skei_n
skeins103911903skeins
skell94915833ske_ll
skells105013783skells
skelm114211283ske_lm
skelp114211423ske_lp
skill94316723s_kill
sleigh10258203sleigh
slily85820033s_lily
smegma1134113smegma
smell74916233sme_ll
smells83914743smells
smelly114110353smelly
smelt74726783sme_lt
smilax1535393s_milax
smile74823923s_mile
snail57020203snail_
snails64816653snails
snell54517303sne_ll
snells64614203snells
social8813333social
soil46138823s_oil_
soils55327983s_oils
sola45541863s__ola
spail74921553spail_
spails84817823spails
special11310303special
specula11187413specula
speel74420763speel_
speels85116393speels
speiled104412123speiled
speir75315363spei_r
speirs85013233speirs
speise84614253speise
speiss84311643speiss
spell75020303spe_ll
spells84617683spells
spelt75430193spe_lt
spheral1238423spheral
spica94717943s_pica
spiel74623913spiel_
spiels85317953spiels
spile75230083s_pile
spill74821163s_pill
spilt75532223s_pilt
spoil75818643spoil_
spoils84614533spoils
spoilt85016593spoilt
squill1537223squill
squilla1635523squilla
steal56125473steal_
steals64020063steals
steel55721993steel_
steels64117983steels
steely93612573steely
stein54620533stei_n
steins64818343steins
stelae63716483ste_lae
stelai63912563ste_lai
stelar64013863ste_lar
stele55026843ste_le
stelic8313083stelic
stellar72610423stellar
stellas72813043stellas
stemma10328133stemma
sterile7316603sterile
sterna63712763sterna
sthenia1058503sthenia
stile54931573s_tile
still54922083s_till
stilt54831983s_tilt
stria55723203stri_a
swail86217163swail_
swails94913123swails
swell84815983swe_ll
swells93913983swells
swill83417373s_will
tela45532973_te_la
telia55821143_telia
tesla55612603_tesla
theca103311453the_ca
thecal113310303thecal
thein85919023thei_n
theine94814923theine
theins95015423theins
their85512153thei_r
theirs94610353theirs
theism1139483theism
theist9314763theist
thenal92712423thenal
theta83414573the_ta
thill85918733th_ill
thrill94910593thrill
thulia936113thulia
veil75523593_veil_
veils84918803_veils
vela75725543_ve_la
voila84813943_voila
wheal115716183wheal_
wheals124512523wheals
wheel115515333wheel_
wheels123811713wheels
whelk154311063whe_lk
whelm134611983whe_lm
whelp136012093whe_lp
while115418693wh_ile

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.1401276364.3
2DLD Change Limit1127164215.61020092.0
3Display Results4214210.1403007.1
 (SQL Overall)1786914215.89030338.0
 
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.