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

269 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
coracles12181116(None) 
coracle112011721coracle_
oracles93212421_oracles
boraces113716852borac_es
caracoles13310072caracoles
cenacles1238022cenacles
chorales133712882chora_les
circles1139902cir_cles
coaches144018692co_aches
corals85325142cora_l_s
cornicles1368242cornicles
crackles164111272c_rackles
cradles103114132c_radles
curacies12311762curacies
miracles1238332miracles
morales93619402mora_les
oraches124216472_oraches
oracle84313292_oracle_
arables91814973_arables
auricles10138333auricles
barnacles1355333barnacles
boracites1347953boracites
borages103917163bora_ges
borals86721913bora_l_s
boranes93720403bora_nes
borates94823013bora_tes
boraxes163511633bora_xes
borecoles1345973borecoles
borsches1536003borsches
boucles113113003bo_ucles
braces108427773_brac_es
braches144621223_braches
broaches153211623broaches
cables104527553c__ables
caches137926913c__aches
cackles153717203c__ackles
calces104420053c__alces
calicles123811433calicles
calycles15295693calycles
caracals12310743caracals
caracks152211563carac_ks
caracole12310353caracole_
caracoled1445983caracoled
caracoler1346413caracoler
caracolers1445123caracolers
caracols12310413caracols
caraculs1238033caraculs
carafes125015703cara_fes
caramels1238803caramels
carates95630613cara_tes
caravels1337433caravels
carcases12313083carcases
carcels114516063car_cels
carices114220953caric_es
carioles10817073carioles
carles85435083c__arles
caroaches1637793caroaches
caroches15710693caroches
caruncles1345003caruncles
caules85927253c__aules
cenacle1139123cenacle_
cerastes101111093cerastes
cerates95428253cera_tes
chicles143512503c_hicles
chloracnes1744443chloracnes
chorale124313353chora_le_
chorals124614113chora_l_s
chortles133611323chor_tles
circle1039703cir_cle_
circled1237583cir_cled
circler1136423cir_cler
circlers1235353cir_clers
circlet11311473cir_clet
circlets1235663cir_clets
coached153313843co_ached
coacher143714123co_acher
coachers154312303co_achers
coacted123611613co_acted
coacts105314333co_ac_ts
coalas87418963co_a_las
coaled95022703co_a_led
coaler84121713co_a_ler
coalers94419353co_a_lers
coalless1038193co_alless
coals76129603co_a_l_s
coatees93816553co_atees
coatless1039693co_atless
coaxes154715633co_a_xes
cobalts1139203coba_lts
cobbles133814823co_bbles
cobles104622883co__bles
cocaines121314443cocaines
cockles153414643co_ckles
codable12311663codable_
coddles114213593co_ddles
codices12512583codic_es
coerces11311943coerc_es
coffles152610003co_ffles
coles76055063co___les
comakes154413643coma_kes
comates114123643coma_tes
compiles14311983compiles
comrades13149773comra_des
concaves1538903concaves
conches144019813co_nches
condoles113015803condoles
condyles14277463condyles
consoles103216153consoles
cooches143515833co_oches
copalms13367543copa_lms
copals105018943copa_l_s
coracoid1348153coracoid
coracoids1445833coracoids
coral76033453cora_l__
corallines1246553corallines
corantoes1147653corantoes
corantos10310103corantos
corbeled1338373corbeled
corbels113813593corbel_s
corbies113520123cor_bies
cordages12310113cordages
cordelles1248233cordelles
cordites11314623cordites
cordless11299963cor_dless
coreless103013833cor_eless
cores76361853cor___es
corkages1539103corkages
cormels113813373cormel_s
corncakes1745013corncakes
corncobs1444723corncobs
cornels94716663cornel_s
cornices12713293cornices
corniches1666673corniches
cornicle1258783cornicle_
cornuses10310033cornuses
corodies11313693corodies
corollas1039213corollas
coronels104012143coronels
corpses113913803cor_pses
corpuscles1642623corpuscles
corpuses12310063corpuses
corrades111211263corrades
corralled1245283corralled
corrals93713853corral_s
corries94026793cor_ries
corrodes111310333corrodes
corsacs1139013corsac__s
corsages11310363corsages
corselet10414573corselet
corselets1147313corselets
corses84433463cor__ses
corslet9318063cor_slet
corslets1038273cor_slets
corteges1198813corteges
cortexes1797613cortexes
cortices12615013cortices
coruler9311713cor_uler
corulers1039773cor_ulers
corvees124613793cor_vees
corves115122523cor__ves
couches144020473co_uches
couples115317053co_uples
courages11311393coura_ges
courantes1148883courantes
covaries13413253covaries
cowages13310933cowa_ges
craaled10339423c_raaled
craals84113303c_raal_s
cracked163514743c_racked
cracker153114173c_racker
crackers164111723c_rackers
crackle153611253c_rackle_
crackled17428863c_rackled
cracks144817003c_rac_ks
cradle93313163c_radle_
cradled113410813c_radled
cradler102910513c_radler
cradlers11309203c_radlers
crakes124921813c_ra_kes
crambes1339963c_rambes
cranches153114543c_ranches
cranes84330753c_ra_nes
crankles143510153c_rankles
crapes104727693c_ra_pes
crases85532313c_ra_ses
crashes124618403c_rashes
cratches153012543c_ratches
crates85736063c_ra_tes
craves115825393c_ra_ves
crawled133710393c_rawled
crawler123510453c_rawler
crawlers13309003c_rawlers
crawls114712083c_rawl_s
crazes174720133c_ra_zes
crazies183413853c_razies
creches14313093c_reches
creoles9913323c_reoles
crotches153411303crotches
crouches153711293crouches
cruces105117543c_ruc_es
cubicles1435883cubicles
curable112414513curable_
curacaos1244923curacaos
curacoas1246033curacoas
curares94916853cura_res
curates95323833cura_tes
curches143512743cur_ches
curdles103814573cur_dles
curricles13105423curricles
cuticles1237893cuticles
cycles1339303c__ycles
debacles1335723debacles
durables11237013durables
earaches13411303earaches
forages114217283fora_ges
forces114422133for_c_es
gorals76917653gora_l_s
gouaches1436193gouaches
graces94523493_grac_es
graciles112511613_graciles
grackles15309183_grackles
hyraces1537913hyrac_es
loaches123613983lo_aches
locales93715093loca_les
macles107023223__macles
manacles1239523manacles
miracle1138843miracle_
monocles12310673monocles
moraines10314363moraines
morale85220553mora_le_
morals85324633mora_l_s
morasses1038903morasses
morelles10710493morelles
movables15175573movables
nopales93812523nopa_les
notables10178243notables
ooralis7312553oora_lis
orache114013593_orache_
orals55826483_ora_l_s
oranges84215333_oranges
orates64328613_ora_tes
orioles7412993_orioles
orles55326213_or__les
parables121613563parables
percales12313803percales
piracies12312643piracies
poaches144416943po_aches
pomaces132712123pomac_es
porches143815673por_ches
portables1337873portables
potables12179703potables
races74943243__rac_es
rales54947493__ra_les
roaches123616213ro_aches
scorches15189143scor_ches
socles8418453so__cles
solaces93116133solac_es
soroches1338803soroches
spiracles1345663spiracles
storables1146283storables
thoraces13118943thorac_es
torches123715433tor_ches
traces85329933_trac_es
trachles13311753_trachles
treacles1039703treacles
utricles1037223utricles
vernacles1445073vernacles
vocables15145733vocables
zorilles1736123zorilles

Search took 9 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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622697.82618676.5
3Display Results2692690.1102445.5
 (SQL Overall)1786912698.10922036.1
 
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.