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

535 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
oracle8431329(None) 
coracle112011721coracle
orache114013591orache
oracles93212421oracles
arable81821002arable
brace95629272brac_e
coracles121811162coracles
crackle153611252crackle
cradle93313162cradle
grace85124542grac_e
gracile102512602gracile
grackle14338892grackle
macle96127002_macle
miracle1138842miracle
morale85220552mora_le
orach105219232orac_h
oraches124216472oraches
oral47638122ora_l_
orally93113592orally
orals55826482ora_ls
orange74016322orange
orate55133302ora_te
oriole6814292oriole
orle45630462or__le
race66746262_rac_e
rackle123917292_rackle
rale45050562_ra_le
trace75829612trac_e
trachle12311852trachle
treacle939972treacle
able66340533__able
ace59656833__ac_e
ache96829823__ache
acme86924323__acme
acne66625873__acne
acre67330773__acre
adorable1138773adorable
ale36572343__a_le
apace94718383apac_e
apache134210773apache
arables91814973arables
arame75026623ara_me
arcade91013643arcade
arcane81216743arcane
areole61017283areole
argle65421563ar_gle
argyle1066063argyle
article9310923article
auricle9139813auricle
axle116424603__axle
bale66353843_ba_le
barnacle1245943barnacle
beadle93314683beadle
beagle93612593beagle
boraces113716853boraces
boracic1338723boracic
boracite1249193boracite
borage93917013bora_ge
boral75831703bora_l_
borals86721913bora_ls
borane84620213bora_ne
borate85026153bora_te
borecole1246623borecole
boucle103712783boucle
brabble10349973brabble
braced115420603braced
bracelet12310693bracelet
bracer104620583bracer
braces108427773braces
brach126123303brac_h
braches144621223braches
brachet144020313brachet
brachs134415753brachs
braciole1246973braciole
bracken15409813bracken
bracket154117233bracket
bract96332723brac_t
bracted12410933bracted
bractlet1239283bractlet
bracts105617773bracts
brae65639113bra__e
brail75525553brail_
brailed103914013brailed
braille939713braille
brails84621293brails
braise84318753braise
braize174113113braize
brake116025343bra_ke
bramble133710033bramble
brattle9249253brattle
brave104925503bra_ve
brawl106217963brawl_
brawled133910123brawled
brawler124310233brawler
brawlie12198153brawlie
brawls115214333brawls
brawly144312353brawly
braze165423453bra_ze
brickle15279933brickle
bricole112810493bricole
bridle94115463bridle
broche133612103broche
cable95329913_cable
cache125122483_cache
cackle143416923_cackle
caracole12310353caracole
carcel105018673carcel
carle74535703_carle
cenacle1139123cenacle
chicle134312543chicle
chorale124313353chora_le
cicale10314503cicale
circle1039703circle
codable12311663codable
coral76033453cora_l_
corals85325143cora_ls
cornicle1258783cornicle
craal74117753craal_
craaled10339423craaled
craals84113303craals
crack134120533crac_k
cracked163514743cracked
cracker153114173cracker
crackled17428863crackled
crackles164111273crackles
crackly18397703crackly
cracks144817003cracks
cracky175010223cracky
cradled113410813cradled
cradler102910513cradler
cradles103114133cradles
crake114823523cra_ke
crambe1239073crambe
crane75331603cra_ne
crankle133610063crankle
crape96128443cra_pe
crate76537403cra_te
crave105626313cra_ve
crawl104916713crawl_
crawled133710393crawled
crawler123510453crawler
crawls114712083crawls
crawly144610763crawly
craze165221463cra_ze
creche13310763creche
creole8913723creole
curable112414513curable
cycle1239523_cycle
dace76934923_dac_e
dale55643983_da_le
darkle113813943darkle
dartle73714833dartle
debacle1237443debacle
doable93115243doable
dowable13189453dowable
drabble12238883drabble
drably123511613drably
drachm1436493drachm
dragee84415603dragee
draggle1056103draggle
drail65020973drail_
drails74716953drails
drake104918303dra_ke
drape85319633dra_pe
drave95219273dra_ve
drawee104413823drawee
drawl95516013drawl_
drawled12368343drawled
drawler11338593drawler
drawls105511393drawls
drawly134910723drawly
dryable13237433dryable
durable102312723durable
dyable12308983dyable
eagle64219483_eagle
earache1239323earache
enable83318483enable
erase54925493era_se
errable9312183errable
exorable1738933exorable
fable105824753_fable
face96140123_fac_e
facile112514883_facile
farce104925323farc_e
farcie114816473farcie
farle86929243_farle
fiacre1137623fiacre
forage104617003fora_ge
force105324273for_c_e
fordable1439593fordable
formable1539503formable
fracas11311993fracas
fracted1339373fracted
fracti1139963fracti
frae75330473fra__e
fragile1147843fragile
frail85220213frail_
frailer10319943frailer
frails93716473frails
fraise94214913fraise
frame105821803fra_me
frappe13286953frappe
frazzle18305223frazzle
freckle16106643freckle
friable122612563friable
fryable15277463fryable
gable85325523_gable
gale56347323_ga_le
garble94118453garble
gargle84215463gargle
glace87420153glac_e
goral65125753gora_l_
gorals76917653gora_ls
gouache1335033gouache
graal64316503graal_
graals74112913graals
grabble12339643grabble
graced105217903graced
graces94523493graces
graciles112511613graciles
grackles15309183grackles
grade75126093gra_de
grail64622873grail_
grails77518783grails
gramme114210333gramme
grange83716203grange
granule839473granule
grape84824663gra_pe
grapple12378003grapple
grate64932883gra_te
grave94624873gra_ve
gravel105313823gravel
grayly13287963grayly
graze155820053gra_ze
grille74315743grille
hackle154916813_hackle
hale76052833_ha_le
haole84820083_haole
hirable121612313hirable
horal86328683hora_l_
icicle1036583icicle
irade65618153ira_de
irate55627983ira_te
kale86533753_ka_le
kraal94511823kraal_
kraaled12254983kraaled
kraals10378433kraals
lace66848473_lac_e
ladle66320443_ladle
liable81415813liable
locale83915653loca_le
loral55927823lora_l_
loricae938253loricae
losable91910953losable
lovable12179553lovable
mace87345793_mac_e
mache125925303_mache
mackle143716433_mackle
macled116718113_macled
macles107023223_macles
macule104115273_macule
maile75232223_maile
male66052303_ma_le
manacle11310283manacle
maple95521143_maple
marble104219103marble
marcel103714853marcel
measle83513223measle
miracles1238333miracles
monocle1139663monocle
morae75831193mora__e
moraine9314573moraine
moral75533433mora_l_
morales93619403mora_les
morally12411493morally
morals85324633mora_ls
morelle91210803morelle
movable14189433movable
muscle10310973muscle
nacre75715363_nacre
notable92114903notable
nuncle839363nuncle
obole75917143o_bole
obstacle1243593obstacle
odyle9349593o_dyle
ogle56325053o__gle
ole37155213o___le
once65423083o_nc_e
oorali6311263oora_li
opal66923523opa_l_
opals75718353opa_ls
opaque1734213opaque
operable12410323operable
ora37250833ora___
oracular1047533oracular
orad56031693ora__d
orang65119943ora_ng
oranges84215333oranges
orangey11388833orangey
orangs74116033orangs
orangy105111233orangy
orated74221503orated
orates64328613orates
orator6314533orator
orc57034923or_c__
orca65522773or_c_a
orcas75918623or_cas
orcin72716573or_cin
orcs67025433or_c_s
ordure756813ordure
ore36661833or___e
oreide7311673oreide
orgone71110913orgone
oriel54920423oriel_
oriels64914623oriels
orioles7412993orioles
orles55326213or__les
ormolu845833ormolu
ornate6315133ornate
oroide7311703oroide
orpine83914483orpine
orrice81410163orrice
oscule838193oscule
osmole8128513osmole
ossicle944483ossicle
ounce77019933ounc_e
outrace92418553outrac_e
oval77119523ova_l_
ovally12278443ovally
ovals85413393ova_ls
ovate84214393ova_te
overable13513573overable
ovule839493o_vule
ownable1237283ownable
pace86345773_pac_e
padle84522343_padle
pale66055013_pa_le
parable111819773parable
parcel103915473parcel
parle75836163_parle
parole84425253parole
peace95026083peac_e
percale11314093percale
place94824613plac_e
pokable15209503pokable
pomace123111913pomac_e
portable12313203portable
posable112212783posable
potable112115363potable
pourable1239133pourable
praise84419413praise
prance104318573prance
prase76128753pra_se
prate75135983pra_te
prattle9208833prattle
price93725413pric_e
prickle153611013prickle
prole74527793pr_ole
quale143617853qua_le
rabble103818243_rabble
raced87635313_raced
raceme1039733_raceme
racer75233023_racer
races74943243_races
rachet115028973_rachet
racier85120973_racier
racily11715173_racily
rack106234883_rac_k
racked134526083_racked
racker124824553_racker
racket125229423_racket
racks115028853_racks
racon75422143_racon
racy95825683_rac_y
raddle84816173_raddle
radicle103510713_radicle
raffle123910703_raffle
rage55742353_ra_ge
ragee65432663_ragee
raggle83712883_raggle
rail46147763_rail_
railed74727543_railed
railer64524933_railer
rails55937403_rails
raise54828053_raise
rake84841573_ra_ke
rakee96031173_rakee
rales54947493_ra_les
rally84725903_rally
rallye95110163_rallye
ramble104519973_ramble
ramee74633853_ramee
ramie75027823_ramie
rance75028513_rance
ranee55438103_ranee
range64728413_range
rankle103414883_rankle
rape65041633_ra_pe
raphe104916423_raphe
rare45348433_ra_re
rase46149983_ra_se
rassle63813203_rassle
rate45458763_ra_te
ratel54224883_ratel
rathe85821923_rathe
rattle64717613_rattle
rave75542093_ra_ve
ravel84621513_ravel
rawly115115833_rawly
raze135235433_ra_ze
razee145827803_razee
recce9514563_recce
rice64942913_ric_e
rifle85518333_rifle
rile45650533_r_ile
rille55728733_rille
roach105717003roac_h
roached133211833roached
roaches123616213roaches
roadie72813813roadie
roble75223023_roble
role45851823_r_ole
rootle63214453rootle
ropable111611333ropable
roscoe839763roscoe
rotche114311983rotche
rouble83913313rouble
rouche114714313rouche
rowable121510303rowable
ruble74521253_ruble
ruche104216763_ruche
ruckle124414583_ruckle
rule49938423_r_ule
sable74732163_sable
sale44959703_sa_le
scale74629143sca_le
shackle16409543shackle
shale85332833sha_le
socle7419573_socle
solace83415823solac_e
sorbable1239303sorbable
soroche1237183soroche
sortable10312483sortable
sowable121610753sowable
space95325673spac_e
spackle15369573spackle
spale74929213spa_le
spiracle1255803spiracle
stable83921643stable
stacte82113913stacte
stale55637103sta_le
staple84415823staple
storable10310733storable
suable83920553suable
swale85221593swa_le
table75429603_table
tace65342513_tac_e
tache106222373_tache
tackle123815733_tackle
tale46154163_ta_le
teazle15329553teazle
tortile7313193tortile
totable92313363totable
towable121910113towable
traced94821583traced
tracer84820233tracer
traces85329933traces
trachea12311673trachea
trachled1438313trachled
trachles13311753trachles
track114823013trac_k
tracked143716133tracked
tracker133515173tracker
tracks124818843tracks
tract75635713trac_t
tractile10311073tractile
tracts85019073tracts
trade65026043tra_de
trail55126773trail_
trailed83415673trailed
trailer73015393trailer
trails64622513trails
tramel84113713tramel
trample11299703trample
trance84718763trance
tranche123312223tranche
trauchle1344963trauchle
trave85223033tra_ve
travel94112983travel
trawl84915873trawl_
trawled113411523trawled
trawler104011903trawler
trawley13317303trawley
trawls94412393trawls
treacles1039703treacles
treacly1237093treacly
treadle8310103treadle
treble8311663treble
triable92515393triable
trice75127493tric_e
trickle133613443trickle
trifle94012883trifle
triple84215923triple
troche113112513troche
truce75118693truc_e
truckle13358863truckle
unable83819223unable
uncle7317053_uncle
uracil8311543uracil
uracils939373uracils
urare56322553ura_re
urase54624683ura_se
urate55432163ura_te
usable84012553usable
utricle937913utricle
vale74937343_va_le
vernacle1345583vernacle
viable111613773viable
vocable14189673vocable
votable122111373votable
wacke145918623_wacke
wale74546433_wa_le
warble113516603warble
warsle93112923warsle
whale115517433wha_le
wirable121610963wirable
workable1737093workable
wrack145413883wrac_k
wracked174110113wracked
wracks154711113wracks
wrangle1137383wrangle
wrasse9398773wrasse
wrassle10357173wrassle
wrastle10368993wrastle
zorille1636673zorille

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 Limit1127165355.93618988.5
3Display Results5355350.1862876.3
 (SQL Overall)1786915356.26228535.8
 
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.