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

298 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
octyl1013606(None) 
octal71214721octal
octyls11135321octyls
acetyl11396552acetyl
acyl95314292ac_yl
butyl1089102butyl
dactyl1234982dactyl
octad81510652octad
octan71313482octan
octet7324062octet
odyl84111462o_dyl
acetal84314903acetal
acetyls12285353acetyls
achy126316093achy_
act59557843act__
acta69524803act_a
acted88521733acted
actin74922553actin
actor71116073actor
acts66929863act_s
actual8311023actual
acyls104211523ac_yls
alkyl12518043alkyl
allyl85310543allyl
amyl95515103_amyl
aortal65217513aortal
aptly105111813aptly
artal55525473artal
artel56122743artel
arty77531313arty_
aryl75922343_aryl
beryl101211673beryl
betel74419903betel
boatel84314093boatel
booty106125913booty_
borty105522833borty_
botel75121863botel
butyls1176753butyls
call66838673_call
carl65144783_carl
caul65630003_caul
cay87155983_cay_
cays95437673_cays
ceil65725063_ceil
cel56040553_c_el
cell65031723_cell
chyle134913483_chyle
city95122623city_
coal66939253_coal
coaly105521593coaly
coccal9310223coccal
coccyx1942663coccyx
cocky164215933cocky_
coil66439653_coil
coital84117053coital
coky137526823coky_
col59360353_c_ol
colly104926773colly
coly96940533coly_
comal95125133comal
cony96537833cony_
cool66940493_cool
cooly105525423cooly
copal95621783copal
copy116229803copy_
coral76033453coral
cory96941513cory_
costal85419513costal
costly114012333costly
cosy97232703cosy_
cot510483223cot__
cotan71521783cotan
cote66648733cot_e
coted85033853coted
cotes76347843cotes
cots68054843cot_s
cotta75818573cotta
cotype1346823cotype
cowl97530813_cowl
cowy126427363cowy_
coxal146116673coxal
coy810557553_coy_
coyly135614893_coyly
coys97537243_coys
cozy185823803cozy_
cry89726243_cry_
cull65929643_cull
curl66035053_curl
dactyli1343603dactyli
dactyls1333913dactyls
dicotyl1344403dicotyl
dicty115116293dicty_
doctor938993doctor
dorty96220813dorty_
dotal64919623dotal
dottel73610893dottel
dotty94516103dotty_
doty86128223doty_
ductal938993ductal
duty85321453duty_
ectypal1442773ectypal
ectype1334283ectype
ethyl1136513ethyl
extol1247893extol
fatal84819373fatal
fatly115716803fatly
fetal85623373fetal
fitly115114973fitly
focal104917673foc_al
foetal9311883foetal
fontal9313143fontal
footy115820533footy_
formyl14276443formyl
forty114824273forty_
gouty95217363gouty_
hexyl1844463hexyl
hooty115022443hooty_
hostel93914153hostel
hostly124210863hostly
hotel85520753hotel
hotly115815483hotly
icily101211693icily
icky136315753icky_
ictic9311803ictic
ictus7249703ictus
icy86322123ic_y_
idyl85912303_idyl
jolty155713033jolty_
jotty155012603jotty_
ketol95414003ketol
local74820273loc_al
lofty115813303lofty_
metal75427383metal
methyl1436403methyl
metol75917813metol
mity95528213mity_
mortal84616853mortal
mostly113110943mostly
motel76623243motel
natal53921493natal
noctule936083noctule
nonyl849773nonyl
notal55221353notal
oaky116419953oaky_
oat39888263oat__
oaten55222403oaten
oater55433733oater
oath76132153oat_h
oaths86117313oaths
oats46554213oat_s
obey96521303obey_
obeys107010643obeys
obol65220613o_bol
oca56731733oc__a
ocas66729633oc_as
occult1038433occult
occur9137323occur
ocean71212963ocean
ocelli836843ocelli
ocher104516103ocher
ochre103411593ochre
ochry13346933ochry
ocker113915753ocker
ocrea73311823ocrea
octads987333octads
octane81411633octane
octanol944743octanol
octans81411143octans
octant81216553octant
octaval1243583octaval
octave11157343octave
octavo11124783octavo
octets839403octets
octopi1036533octopi
octroi837363octroi
octuple1153993octuple
octuply1443133octuply
oculi72010793oculi
oddly1037163oddly
odyle9349593o_dyle
odyls9428653o_dyls
ofay106416103ofay_
ofays11488923ofays
offal1136243offal
oft67744063oft__
often84611413often
ofter84116873ofter
oil37452053o__il
oily77932253oily_
okay115917663okay_
okays12609443okays
oldy85316843oldy_
only75319723only_
ontic74418573ontic
onto46127663ont_o
onyx1478363o_nyx
oocyte1135753oocyte
oot311274693oot__
ootid61416703ootid
oots46446443oot_s
oozy167018133oozy_
opal66923523o_pal
opt57545543opt__
opted84914273opted
optic93715183optic
opts68124743opt_s
oral47638123o_ral
orby97519603orby_
orchil1158653orchil
orgy85218003orgy_
oriel54920423oriel
ort39465233ort__
ortho8312293ortho
orts46538333ort_s
oryx14510213o_ryx
osmol7138573osmol
osteal6312963osteal
ostia52315583ostia
otic66624823o_tic
ottar54313993ottar
otter54423973otter
otto45220643o_tto
ottos54714323ottos
ousel55222403ousel
out38072153out__
outby10411533outby
outbye1147913outbye
outdo6312703outdo
outed65429063outed
outer55633303outer
outfly1238273outfly
outgo6312093outgo
outre53922203outre
outs45746963out_s
outyell1095843outyell
outyelp1294323outyelp
ouzel144612323ouzel
oval77119523o_val
owl66228973o__wl
oxeye1536913oxeye
oxtail1337653oxtail
oxter123414093oxter
oxy136320983o_xy_
oy58950133o__y_
patly105020583patly
paty95234563paty_
pentyl1138813pentyl
petal76526893petal
pity96031933pity_
pocky165314603pocky_
pontil8315463pontil
portal84218463portal
portly114713403portly
postal84317533postal
potty105621003potty_
pouty107018813pouty_
protyl11308213protyl
ratal55025113ratal
ratel54224883ratel
rectal84418133rectal
rictal83113183rictal
rocky144513853rocky_
rooty86423023rooty_
rotl45029683rot_l
satyr848483satyr
scall74420373scall
scaly104718723scaly
schul102510413schul
scowl1012012973scowl
scry96017763scry_
scull75315763scull
setal56430903setal
sibyl1037113sibyl
social8813333social
softly12457763softly
softy115414483softy_
sooty84924843sooty_
sotol54917653sotol
sty66227313_sty_
stye76218973_stye
style85519363_style
styli83911173_styli
tectal83713253tectal
tel35647903__tel
tetryl935693tetryl
til36350263__til
toluyl933443toluyl
tolyl84710093tolyl
total55321823total
trotyl9236673trotyl
tye65837443__tye
until53517743until
vinyl115311623vinyl
vital84819673vital
vocal104715643voc_al
wetly114511713wetly
xylyl1842563xylyl
zooty175415353zooty_

Search took 4 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 Filter178691836670.343520965.0
2DLD Change Limit836672983.37624782.9
3Display Results2982980.0763921.1
 (SQL Overall)1786912983.79547085.9
 
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.