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

383 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
carioles1081706(None) 
cabrioles1376361cabrioles
caprioles1376751caprioles
cariole9818341cariole_
carrioles1169471carrioles
darioles9710691darioles
varioles11711121varioles
areoles71016952_areoles
cabriole1276932cabriole_
cabriolet1377482cabriolet
cabriolets1463372cabriolets
cajoles163712102ca_joles
calicles123811422calicles
camisoles1345572camisoles
capriole1276912capriole_
caprioled1464742caprioled
caracoles13310072caracoles
cargoes104415222cargo_es
caribes113715642cari_bes
carices114220952cari_ces
caries85147622cari__es
cariocas1239662cariocas
carious93320282cario_us
carles85435082car__les
caroled103717682car_oled
caroler93816752car_oler
carolers103314172car_olers
carols85124982car_ol_s
carolus94612602car_olus
carriole1089862carriole_
creoles9913322c_reoles
dariole8711162dariole_
orioles7412992_orioles
ovarioles1244602ovarioles
paroles95025882par_oles
variolas1168532variolas
variole10711592variole_
abioses9311493_abioses
acarboses1345083acarboses
acariases1146613acariases
acarines10314343acari_nes
achiotes1339003achiotes
aiolis6316843_a_iolis
airholes1138033airholes
aisles64721143_a_isles
amoles84122193_a_moles
anisoles81010123_anisoles
anoles64827423_a_noles
arables91814973_arables
arbores94016033_arbores
areolas71013863_areolas
areole61017283_areole_
argles75218483_ar_gles
argols74514613_argol_s
argyles1136053_argyles
ariels65119373_ariel_s
ariled75620323_ari_led
arils58732203_ari_l_s
ariose64818723_ariose_
ariosos7409853_ariosos
arises65233803_ari_ses
arkoses113910833_arkoses
arles56735743_ar__les
armholes1347383_armholes
articles10310243_articles
aureoles838283aureoles
auricles10138333auricles
azoles154614613_a_zoles
barbules1238043barbules
barillas10310193barillas
barites94322333bari_tes
baritones1158943baritones
bracioles1346493bracioles
brailles1039483brailles
bricoles122610303_bricoles
bridles104114473_bridles
cables104527553ca__bles
caboodles1443283caboodles
cabooses1237863cabooses
cabrillas1345603cabrillas
caciques21165373caciques
cackles153717203ca_ckles
cadelles1139953cadelles
caiques18248793ca_iques
cajole154011183ca_jole_
cajoled17428273ca_joled
cajoler16398393ca_joler
cajolers17267133ca_jolers
cajones163311333ca_jones
calcicoles1344023calcicoles
calibres1237103calibres
calices114321693cali_ces
caliches153812263caliches
calicle113111433calicle_
calicoes123911583calicoes
calipees1247413calipees
calliopes1346143calliopes
calloses10313383calloses
calycles15295693calycles
calzones1948763calzones
camions113916133camio_ns
camises114218463cami_ses
camisole1246173camisole_
canailles1148263canailles
candles104422343ca_ndles
canines93724033cani_nes
canities101519243canities
cannolis1037863cannolis
canoes84725883ca_no_es
canolas9313993ca_nolas
canoodles1243993canoodles
canticles1339183canticles
cantles94721413ca_ntles
canzones1939153canzones
capiases1239253capiases
capitols12247333capitol_s
capizes20410373capi_zes
capotes11314643ca_potes
caprices1439893capri_ces
capsules1236623capsules
caracole12310353caracole_
caracoled1445983caracoled
caracoler1346413caracoler
caracolers1445123caracolers
caracols12310413caracol_s
carafes125015703car_afes
caramels1238803caramels
carates95630603car_ates
caravels1337433caravels
carbazoles2343593carbazoles
carbides133111693carbides
carbines123617533carbines
carbinols1346103carbinol_s
carbolic1448323carbolic
carbolics1546723carbolics
carbolizes23178163carbolizes
carbonless1444083carbonless
carbons115418943carbo_ns
carboras12311573carboras
carbos105122263carbo__s
carboyed1637183carboyed
carboys144711783carbo_ys
carcases12313083carcases
carcels114516063carcel_s
cardioids1345223cardioids
cardons104519933cardo_ns
cardoons113411943cardoons
careless102813633car_eless
cares77369183car___es
caresses10314063caresses
carfares13310323carfares
carfuls1249133carful_s
cargos94619183cargo__s
carhops14329703carho_ps
caribe103416743cari_be_
caribous1258823caribous
caried94528693cari__ed
carillon1046953carillon
carillons1146333carillons
carinae94318583carinae_
carinas93622383cari_nas
carioca1139683cario_ca
caritas93316943cari_tas
caritases1139743caritases
carle74535703car__le_
carless95118493car__less
carlines103521643carlines
carloads1138393carloads
carls77037423car__l_s
carmines123617863carmines
carnages11312213carnages
carnies94123963car_nies
carnifies1439893carnifies
carnivores1553363carnivores
carobs104818103car_o_bs
caroches15710693caroches
carol75128613car_ol__
caroli85918233car_ol_i
carolled1138823carolled
caroller1039203caroller
carollers1137703carollers
caroluses1157613car_oluses
caromed123713623car_omed
caroms105619573car_o_ms
carouse9614423car_ouse
carouses10614503carouses
carpale113414353carpale_
carpals113414623carpal_s
carpels115315463carpel_s
carpooled1445063carpooled
carpooler1345313carpooler
carpoolers1444573carpoolers
carpools1237883carpools
carports1238943carports
carrells10359263carrells
carrels95117303carrel_s
carriages1238333carriages
carries94328013car_ries
carrions10312443carrio_ns
carroches1665893carroches
carromed1338563carromed
carroms11512403carro_ms
carrots9714623carro_ts
carses85233653car__ses
cartages11313313cartages
cartels94618123cartel_s
cartes86239473car__tes
cartoned111312833cartoned
cartons94122473carto_ns
cartoons104012803cartoons
caruncles1345003caruncles
carvels124914593carvel_s
carves115128453car__ves
caryopses1645043caryopses
caseoses1039293caseoses
castles94917733ca_stles
cataloes10311643cataloes
cathodes1439373cathodes
cations94524143catio_ns
caudles103912813ca_udles
caules85927253ca__ules
caulicles1344383caulicles
caviares1337993caviares
cavies114525003cavi__es
caviled1348723cavi_led
caviler1249063cavi_ler
cavilers1348113cavi_lers
cavilled1436723cavilled
caviller1337053caviller
cavillers1435603cavillers
cavils114014393cavi_l_s
cavities131412613cavities
caziques28193773caziques
centrioles1245803centrioles
cerises94722253ceri_ses
cerites94823433ceri_tes
charioted1595863charioted
chariots1339393chario_ts
charities14312733charities
chicles143512503c_hicles
chiles115425303c_hi_les
chromes142914933chr_omes
cineoles10109403cineoles
circles1139903cir_cles
citoles9312553c_itoles
claries93422203clari__es
clarifies1448633clarifies
clarioned1245723clarioned
clarionet1149833clarionet
clarionets1243903clarionets
clarions10310493clario_ns
clarities11312483clarities
claroes93113733clar_o_es
clavicles1643663clavicles
coalholes1445373coalholes
coles76055063c___oles
condoles113015803condoles
conioses10313313conioses
consoles103216153consoles
coracles121811163coracles
cornicles1368243cornicles
corrodes111310333corrodes
crackles164111273crackles
cradles103114123c_radles
crankles143510153crankles
crapolas1247403crapolas
creole8913723c_reole_
cries75438403c_ri__es
crimes105521583c_ri_mes
crimples14308963c_rimples
cringes103215503c_ringes
cringles11329463c_ringles
crinkles14269163c_rinkles
criollo943953c_riollo
criollos1043713c_riollos
cripes105120873c_ri_pes
cripples14298403c_ripples
crises84529433c_ri_ses
crones84729243c_r_ones
crores86121163c_r_ores
crozes174417663c_r_ozes
cubicles1435883cubicles
curdles103814573cur_dles
curies84934023curi__es
curios83218333curio__s
curious93813563curio_us
curites93919863curi_tes
curricles13105423curricles
cuticles1237893cuticles
darkles124011933dar_kles
dartles84014133dar_tles
earlobes1056143earlobes
escaroles1145263escar_oles
failles102914123fa_illes
farles96025783far__les
frijoles1834373_frijoles
garbles104016923gar_bles
gargles94214893gar_gles
gargoyles1442833gargoyles
garigues1034953garigues
garotes8614563gar_otes
garrotes969363garrotes
glorioles1044263glorioles
grilles83715023_grilles
haoles94919803ha__oles
karaokes1145013karaokes
liriopes1043883liriopes
mailes84329113ma_i_les
manholes13311183manholes
manilles102312593manilles
maniples12269423maniples
marbles114516653mar_bles
marigolds1343083marigolds
marines93928013mari_nes
marishes13512553marishes
maypoles1545993maypoles
narcoses103910533narcoses
nargiles976793nargiles
oriole6814293_oriole_
ostioles839273ostioles
ovariole1144913ovariole_
panicles121010103panicles
parables121613563parables
paries84742513pari__es
parietes10714543parietes
parises94827183pari_ses
parishes13314753parishes
parities10522973parities
parles86334393par__les
parole84425253par_ole_
paroled104217613par_oled
parolee94119633par_olee
parolees104313973par_olees
parols84722613par_ol_s
particles1339803particles
petioles10311633petioles
proles84627203_pr_oles
pyrroles1345453pyrroles
radicles11249693radicles
rampoles1238893rampoles
rarifies11311933rarifies
rarities8316333rarities
ratholes11312413ratholes
raviolis1146103raviolis
rifles94217703__rifles
riles55343643__ri_les
rilles64725503__rilles
roles56747983__r_oles
safroles1136933safroles
sanicles10149943sanicles
sarodes84216143sar_odes
saroses73619333sar_oses
scarifies1439603scarifies
scariose1037593scariose_
scarious10610203scario_us
tadpoles1135953tadpoles
tailles72516463ta_illes
tapholes1339623tapholes
trifles103814823_trifles
triodes84012503_triodes
triolet73219523_triolet
triolets83410143_triolets
triols66117803_triol_s
trioses75015653_trioses
triples94616873_triples
utricles1037223utricles
vacuoles1345013vacuoles
variables1444673variables
variates111214973variates
varices123313573vari_ces
varicoses1446653varicoses
varies94330873vari__es
variola1068893variol_a
variolar1176343variolar
variolates1347453variolates
variolites1346673variolites
variolous1244983variolous
various103113103vario_us
warbles123215563war_bles
warsles103413643war_sles
warstles11368803warstles
wavicles1633783wavicles
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.1561145455.1
2DLD Change Limit1461623838.14017956.0
3Display Results3833830.1402735.7
 (SQL Overall)1786913838.43621182.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.