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

299 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
coracle11201172(None) 
coracles121811161coracles
oracle84313291_oracle
caracole12310352caracole
cenacle1139122cenacle
chorale124313352chora_le
circle1039702cir_cle
codable12311662codable
coral76033452cora_l_
corals85325142cora_ls
cornicle1258782cornicle
crackle153611252c_rackle
cradle93313162c_radle
curable112414512curable
miracle1138842miracle
morale85220552mora_le
orache114013592_orache
oracles93212422_oracles
adorable1138773adorable
arable81821003_arable
auricle9139813auricle
barnacle1245943barnacle
boraces113716853boraces
boracic1338723boracic
boracite1249193boracite
borage93917013bora_ge
boral75831703bora_l_
borals86721913bora_ls
borane84620213bora_ne
borate85026153bora_te
borecole1246623borecole
boucle103712783bo_ucle
brace95629273_brac_e
cable95329913c__able
cache125122483c__ache
cackle143416923c__ackle
calicle113111433calicle
calycle14245833calycle
capable13313363capable
caracal11312513caracal
caracals12310753caracals
carack142113173carac_k
caracks152211563caracks
caracol11310423caracol
caracoled1445983caracoled
caracoler1346423caracoler
caracoles13310073caracoles
caracols12310413caracols
caracul1138823caracul
caraculs1238033caraculs
carafe115416163cara_fe
caramel11310253caramel
carate84734003cara_te
caravel1238213caravel
carcase11312743carcase
carcel105018673car_cel
cariole9818343cariole
carle74535703c__arle
caroche1469243caroche
carpale113414353carpale
cartable121314093cartable
caruncle1244713caruncle
cenacles1238023cenacles
cerate84829463cera_te
cercal10314123cercal_
chicle134312543c_hicle
chloracne1644513chloracne
choral115118493chora_l_
chorales133712883chora_les
chorally1638103chorally
chorals124614113chora_ls
chortle124210443chor_tle
cicale10314503cica_le
circled1237583cir_cled
circler1136423cir_cler
circles1139903cir_cles
circlet11311473cir_clet
citable11313463citable
cloacae1145233cloacae
closable12168003closable
coach125919453co_ac_h
coached153313843co_ached
coacher143714123co_acher
coaches144018693co_aches
coact96130583co_ac_t
coacted123611613co_acted
coacts105314333co_acts
coal66939253co_a_l_
coala77521123co_a_la
coaled95022713co_a_led
coaler84121713co_a_ler
coals76129603co_a_ls
coaly105521593co_a_ly
coarse84813903co_arse
coatee84327223co_atee
cobalt10317393coba_lt
cobble123615263co_bble
coble94823173co__ble
cocaine111315173cocaine
coccal9310223coccal_
cockle143913573co_ckle
coddle104713853co_ddle
coerce10310403coerc_e
coffle14359043co_ffle
coinable12311583coinable
cole66956113co___le
colorable1348243colorable
comade114415323coma_de
comae97128423coma__e
comake144413423coma_ke
comal95125133coma_l_
comate104124843coma_te
compile13312443compile
comrade12139213comra_de
concave1439373concave
condole102914953condole
condyle13247053condyle
console92715983console
cookable16147973cookable
copal95621783copa_l_
copalm125010813copa_lm
copals105018943copa_ls
copyable1736623copyable
coracoid1348153coracoid
coralline1147943coralline
coranto9311893coranto
corbel103715973corbel_
corbeled1338373corbeled
corbels113813593corbels
corbie103618203cor_bie
cordage11310063cordage
cordate10315223cordate
cordelle1148433cordelle
cordite10315263cordite
core67263113cor___e
corkage1438373corkage
cormel103815603cormel_
cormels113813373cormels
corncake1645263corncake
corncob1345663corncob
cornel84020053cornel_
cornels94716663cornels
cornice11612933cornice
corniche1575923corniche
cornicles1368243cornicles
cornily12410853cornily
cornute939643cornute
corolla938623corolla
coronae94214893coronae
coronel94515223coronel
corpse104013403cor_pse
corpuscle1542993corpuscle
corrade101111043corrade
corral83616253corral_
corralled1245283corralled
corrals93713853corrals
corrie83621223cor_rie
corrode101310573corrode
corsac10410173corsac__
corsacs1139013corsac_s
corsage1039803corsage
corse75036183cor__se
corselet10414573corselet
corslet9318063cor_slet
cortege1098953cortege
coruler9311713cor_uler
corvee114320093cor_vee
corvine122113643corvine
couple104415963co_uple
courage10310993coura_ge
courante1049953courante
coverable1649103coverable
cowage12310673cowa_ge
coxae146115183coxa__e
coxal146116673coxa_l_
craal74117753c_raal_
craaled10339423c_raaled
craals84113303c_raals
crack134120533c_rac_k
cracked163514743c_racked
cracker153114173c_racker
crackled17428863c_rackled
crackles164111273c_rackles
crackly18397703c_rackly
cracks144817003c_racks
cracky175010223c_racky
cradled113410813c_radled
cradler102910513c_radler
cradles103114133c_radles
crake114823523c_ra_ke
crambe1239073c_rambe
crane75331603c_ra_ne
crankle133610063c_rankle
crape96128443c_ra_pe
crate76537403c_ra_te
crave105626313c_ra_ve
crawl104916713c_rawl_
crawled133710403c_rawled
crawler123510463c_rawler
crawls114712083c_rawls
crawly144610763c_rawly
craze165221463c_ra_ze
creche13310763c_reche
creole8913733c_reole
cubicle1337003cubicle
curably142010773curably
curacao1146293curacao
curacies12311763curacies
curacoa1146223curacoa
curacy1339593curac_y
curare84916953cura_re
curate85226243cura_te
curbable1447663curbable
curdle95514313cur_dle
curricle12145933curricle
curule83614123cur_ule
cuticle1138233cuticle
cycle1239523c__ycle
debacle1237443debacle
doable93115243do_able
dowable13189453dowable
durable102312723durable
earache1239323earache
errable9312183errable
exorable1738933exorable
forage104617003fora_ge
force105324273for_c_e
fordable1439593fordable
formable1539503formable
goral65125753gora_l_
gorals76917653gora_ls
gouache1335033gouache
grace85124543_grac_e
gracile102512603_gracile
grackle14338893_grackle
hirable121612313hirable
horal86328683hora_l_
locale83915653loca_le
loral55927823lora_l_
loricae938253loricae
losable91910953losable
lovable12179553lovable
macle96127003__macle
manacle11310283manacle
miracles1238333miracles
monocle1139663monocle
morae75831193mora__e
moraine9314573moraine
moral75533433mora_l_
morales93619403mora_les
morally12411493morally
morals85324633mora_ls
morelle91210803morelle
movable14189433movable
notable92114903notable
oorali6311263oora_li
orach105219233_orac_h
oraches124216473_oraches
oral47638123_ora_l_
orally93113593_orally
orals55826483_ora_ls
orange74016323_orange
orate55133303_ora_te
oriole6814293_oriole
orle45630463_or__le
parable111819773parable
percale11314093percale
pokable15209503pokable
pomace123111913pomac_e
portable12313203portable
posable112212783posable
potable112115363potable
pourable1239133pourable
race66746263__rac_e
rackle123917293__rackle
rale45050563__ra_le
ropable111611333ropable
rowable121510303rowable
socle7419573so__cle
solace83415823solac_e
sorbable1239303sorbable
soroche1237183soroche
sortable10312483sortable
sowable121610753sowable
spiracle1255803spiracle
storable10310733storable
tortile7313193tortile
totable92313363totable
towable121910113towable
trace75829613_trac_e
trachle12311853_trachle
treacle939973treacle
utricle937913utricle
vernacle1345583vernacle
vocable14189673vocable
votable122111373votable
wirable121610963wirable
workable1737093workable
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 Filter1786911340270.406440125.6
2DLD Change Limit1340272996.26321399.8
3Display Results2992990.1102718.2
 (SQL Overall)1786912996.77926359.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.