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

498 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
cajoles16371210(None) 
cajole154011181cajole_
cajoled17428271cajoled
cajoler16398391cajoler
cajolers17267131cajolers
cajones163311331cajones
amoles84122192_amoles
anoles64827422_anoles
azoles154614612_azoles
cables104527552ca_bles
cackles153717202cackles
cajolery20253572cajolery
candles104422342candles
canoes84725882cano_es
canolas9313992canolas
cantles94721412cantles
capotes11314642capotes
carioles10817052carioles
carles85435082ca_rles
caroled103717682caroled
caroler93816752caroler
carolers103314172carolers
carols85124982carol_s
carolus94612602carolus
castles94917732castles
caudles103912812caudles
caules85927252ca_ules
citoles9312552citoles
cojones163512102cojones
coles76055062c__oles
creoles9913322creoles
haoles94919802ha_oles
joles125230832__joles
paroles95025872paroles
abeles84719393_abeles
ables75935543_a_bles
abodes94417513_abodes
aboves114512843_aboves
acajous1666483acajo_us
acnodes1037823acnodes
addles84216603_addles
adobes94411523_adobes
adores74420713_adores
agones75719863_agones
aholds10469483_aholds
aiolis6316843_aiolis
aisles64721143_aisles
ales47067103_a__les
aloes54933673_alo_es
ambles105121853_ambles
amole75724593_amole_
aneles64626293_aneles
angles74426703_angles
ankles104818383_ankles
anodes74418753_anodes
anole55330373_anole_
apples104315763_apples
areoles71016943areoles
argles75218483_argles
arles56735743_a_rles
atolls65511353_atolls
atones65225773_atones
awols84713523_awol_s
axles125219473_a_xles
axones134614513_axones
azole145118033_azole_
azotes154312223_azotes
babbles104416313babbles
baffles153710683baffles
bales76250083ba__les
bangles103617413bangles
banjoes16317313banjo_es
battles94517683battles
baubles113611863baubles
boles75448603__boles
cabalas113516003cabalas
cabals104020153cabal_s
cabbies133115153cabbies
cable95329913ca_ble_
cabled114819873ca_bled
cabler104519173ca_bler
cablers114416713ca_blers
cablet104429463ca_blet
cablets114216343ca_blets
cabobs124311883cabo_bs
caboodles1443283caboodles
caboose1138273caboose
cabooses1237863cabooses
cabrioles1376353cabrioles
caches137926913ca_ches
cackle143416923cackle_
cackled164613293cackled
cackler153812573cackler
cacklers163710703cacklers
caddies113718383caddies
cadelles1139953cadelles
cades85440733ca__des
cadges104716703ca_dges
cadres94017923ca_dres
caeomas1138393caeomas
cafes106426923ca__fes
cages85936013ca__ges
cahoots1238473cahoots
cahows14399123caho_ws
caiques18248793caiques
cajoleries1944753cajoleries
cajoling18318423cajoling
cajon144513903cajo__n
cakes116037673ca__kes
calces104420053ca_lces
calesa8412473ca__lesa
calfs104919383ca__lfs
calices114321693calices
calicles123811423calicles
calks115421603ca__lks
callas84526753ca_llas
called94126733ca_lled
callee84327293ca_llee
callees94117773callees
caller85125483ca_ller
callers94221963ca_llers
callet84536763ca_llet
callets93821703ca_llets
callose9313653callose
calloses10313383calloses
callous93516593callous
calls75634733ca__lls
callus85317073ca_llus
calms95222353ca__lms
calomel1138073calomel
calomels1236133calomels
calories102919543calories
calos74431903ca__los
calottes10610083calottes
caloyer1238143caloyer
caloyers1337343caloyers
calques182710193calques
calves115119283ca_lves
calxes154113033ca_lxes
calyces14428803calyces
calycles15295693calycles
calyxes19426233calyxes
calzones1948763calzones
camases114216343camases
camels105217083camel_s
cames97047313ca__mes
camises114218463camises
camisoles1345573camisoles
camlet104426583ca_mlet
camlets114314623ca_mlets
cammies134016473cammies
camomiles15155633camomiles
camos95927613camo__s
canaled103615553canaled
canals84421663canal_s
canapes111213083canapes
cancels114113313cancels
candies104125613candies
candle94321483candle_
candled113815733candled
candler103516593candler
candlers114214103candlers
canes75350373ca__nes
cangues10611823cangues
canines93724033canines
cannels93413363cannels
cannolis1037863cannolis
canoe75627253cano_e_
canoed94618953cano_ed
canoer85121073cano_er
canoers94318373canoers
canola8313623canol_a
canoness1039393canoness
canons85522063cano_ns
canoodles1243993canoodles
canopies12311853canopies
cantle84522153cantle_
canulas9312843canulas
canzones1939153canzones
capelet11517073capelet
capelets1268603capelets
capes95441923ca__pes
capizes20410373capizes
capless114312763ca_pless
caplet104226813ca_plet
caplets114914523ca_plets
capons104119503capo_ns
capos94826073capo__s
capote10315733capote_
caprioles1376743caprioles
capsules1236623capsules
caracoles13310063caracoles
carafes125015703carafes
carates95630603carates
carcels114516063carcels
careless102813633careless
cares77369183ca__res
cargoes104415223cargoes
caribes113715643caribes
carices114220953carices
caries85147623ca_ries
cariole9818343cariole_
carle74535703ca_rle_
carless95118493ca_rless
carls77037423ca_rl_s
carnies94123963carnies
carobs104818103caro_bs
caroches15710693caroches
carol75128613carol__
caroli85918233carol_i
carolled1138823carolled
caroller1039203caroller
carollers1137703carollers
caroluses1157613caroluses
caromed123713623caromed
caroms105619573caro_ms
carouse9614423carouse
carouses10614503carouses
carpels115315463carpels
carrels95117303carrels
carries94328013carries
carrioles1169463carrioles
carses85233653ca_rses
cartels94618123cartels
cartes86239473ca_rtes
carvels124914593carvels
carves115128453ca_rves
caseoses1039293caseoses
cases75048383ca__ses
cashes114729883ca_shes
cashless1336773cashless
casques18278983casques
castes85631863ca_stes
castle84918963castle_
castled104311513castled
cataloes10311643cataloes
catalos9414163catalos
catches144320763catches
cates75951873ca__tes
cathodes1439373cathodes
catties94023053catties
cattle85118903cattle_
caudle93912913caudle_
caulds95512383ca_ulds
caulis85320073ca_ulis
caulks125611863ca_ulks
cauls75727773ca_ul_s
causes88026473ca_uses
caves105639703ca__ves
cavies114525003ca_vies
caviled1348723caviled
caviler1249063caviler
cavilers1348113cavilers
cavils114014393cavil_s
cavorts1237933cavorts
cayuses12188403cayuses
cenotes92814543cenotes
chalones13312173chalones
chaoses124715113chaoses
chayotes1636493chayotes
chicles143512503chicles
chiles115425303c_hiles
chokes154917383c_hokes
cholas114817993c_holas
choler113717153c_holer
cholers124215193c_holers
cholos114716853c_holos
chooses125717413chooses
chores114828023c_hores
choses115825123c_hoses
chromes142914933chromes
chyles144813283c_hyles
cibols1039523cibol_s
ciboules1244533ciboules
cineoles10109403cineoles
circles1139903circles
citolas939343citolas
citole8311503citole_
cladodes1245323cladodes
claroes93113733claro_es
cleomes1138813cleomes
clones84526563c_lones
closes85425593c_loses
cloves114918823c_loves
clozes174915563c_lozes
coalholes1445373coalholes
cobbles133814813cobbles
cobles104622883c_obles
cockles153414643cockles
coddles114213593coddles
codes86247293c__odes
coffles152610003coffles
cojoins1638993cojoins
cokes115537193c__okes
colas75436773c__olas
colds85726973c__olds
cole66956113c__ole_
coled85540753c__oled
coleus86818273c__oleus
colies84837053c__olies
colones96124423colones
cols66553083c__ol_s
colts76633293c__olts
comes97246993c__omes
condoles113015803condoles
cones76457423c__ones
consoles103216153consoles
cooees85621893c_ooees
cooled95224583c_ooled
cooler84824713c_ooler
coolers93522493c_oolers
coolest9318643c_oolest
coolies93824963c_oolies
cools75632633c_ool_s
copes97747103c__opes
cores76361853c__ores
coses76949493c__oses
cotes76347843c__otes
couples115317053couples
coves105539173c__oves
coxes145430863c__oxes
coyotes12410703coyotes
cozes166033243c__ozes
crackles164111273crackles
cradles103114123cradles
crankles143510153crankles
crapolas1247393crapolas
creole8913723creole_
crones84729243c_rones
crores86121163c_rores
crozes174417663c_rozes
cuddles114014093cuddles
cupolas11277753cupolas
cupules113210263cupules
curdles103814573curdles
cuttles93613923cuttles
cyanoses1337423cyanoses
cycles1339303c_ycles
cymols1377193cymol_s
dabbles124514763dabbles
daddles104213803daddles
dadoes85616533dado_es
daggles103611913daggles
dagoes85714603dago_es
dales66439743da__les
dalles74222063da_lles
dandles94218533dandles
dangles93618423dangles
dapples1238993dapples
darioles9710683darioles
darkles124011933darkles
dartles84014133dartles
dawdles12379163dawdles
dazzles1636413dazzles
dholes104914793_dholes
diazoles1836323diazoles
dipoles101013753dipoles
doles67843753__doles
eagles73819163ea_gles
escaroles1145253escaroles
fables114921673fa_bles
failles102914123failles
farles96025783fa_rles
frijoles1834373frijoles
gabbles124415403gabbles
gables94222333ga_bles
gaggles103512593gaggles
gales65442483ga__les
galores82614323galores
gambles124016203gambles
gaoled84814493ga_oled
gaoler73913573ga_oler
gaolers83511563ga_olers
gaols66717573ga_ol_s
garbles104016923garbles
gargles94214893gargles
garotes8614563garotes
hackles162917063hackles
haggles123312483haggles
hajes155420943haj__es
hajjes15485243haj_jes
hales85449843ha__les
halloes104021513halloes
haloes94623863halo_es
handles114020653handles
hantles104117513hantles
haole84820083ha_ole_
hassles103411693hassles
holes84748653__holes
indoles83716363indoles
insoles73516243insoles
jacales16310323jacales
jangles154015683jangles
joes116635893__jo_es
jokes165423333__jokes
jole117233823__jole_
jolts125018883__jolts
jones125028183__jones
joules134116823__joules
kales95730983ka__les
kayles134712003ka_yles
kayoes134710823kayo_es
ladles74619543la_dles
mackles154415753mackles
macles107023223ma_cles
macules114015133macules
mahoes11313103maho_es
mailes84329113ma_iles
majored1735853majored
majors154511093majo_rs
males75049793ma__les
mangles104021463mangles
manholes13311183manholes
mantles94820703mantles
maples104819423ma_ples
marbles114516653marbles
maypoles1545983maypoles
mojoes15399523mojo_es
moles74747923__moles
oboles83815833_oboles
oles46453473___oles
orioles7412993orioles
osmoles9138363osmoles
paddles113515633paddles
padles95221113pa_dles
pales75753803pa__les
papules112411573papules
parles86334393pa_rles
parole84425253parole_
paroled104217613paroled
parolee94119633parolee
parolees104313973parolees
parols84722613parol_s
payolas12148973payolas
pinoles93418703pinoles
poles75351003__poles
posoles9314883posoles
pozoles1839063pozoles
proles84627193_proles
rabbles113517963rabbles
raddles93615703raddles
radomes10311043radomes
raffles133611843raffles
raggles93813283raggles
rajes125022783raj__es
rales54947493ra__les
rambles113118313rambles
rampoles1238883rampoles
rankles113114543rankles
rassles73513923rassles
ratholes11312403ratholes
rattles73217303rattles
resoles73823653resoles
roles56747983__roles
sables85026693sa_bles
saddles95415743saddles
safroles1136923safroles
sajous13310583sajo_us
sales56055593sa__les
salols64017873salol_s
samples112815453samples
sapotes9313933sapotes
sarodes84216143sarodes
saroses73619333saroses
scabbles14167983scabbles
scales84529313sca__les
skatoles1236143skatoles
soles55547923__soles
stoles63927673_stoles
tables84524883ta_bles
tackles133816523tackles
tadpoles1135943tadpoles
tailles72516463tailles
tajes124920693taj__es
tales55451373ta__les
tamales93216143tamales
tangles83920043tangles
tapholes1339613tapholes
tattles73616283tattles
taxols13328633taxol_s
tholes94919783_tholes
toles55147133__toles
vacuoles1345013vacuoles
vales85434263va__les
vamoses1239143vamoses
varioles11711113varioles
voles86234043__voles
wabbles144013983wabbles
waddles124314843waddles
waffles16329983waffles
waggles123812003waggles
wales86142833wa__les
wambles143714023wambles
wangles113416933wangles
warbles123215563warbles
warsles103413643warsles
wattles103814073wattles
wholes124616773_wholes

Search took 8 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.1561145455.1
2DLD Change Limit1340274987.46617951.6
3Display Results4984980.1732878.6
 (SQL Overall)1786914987.79522923.8
 
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.