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

380 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
caresses1031406(None) 
caressed1139161caressed
caresser1038811caresser
caressers1137441caressers
cresses94219811c_resses
accesses1287492accesses
actresses1137932actresses
camasses12388972camasses
carcases12313092carcases
carcasses1337482carcasses
careless102813632careless
caress85720262care_s_s
carouses10614502carouses
carses85233652car__ses
caseases10410472caseases
caseoses1039292caseoses
cateresses1248352cateresses
cereuses1049242cereuses
cesses84221362c__esses
chesses124112632c_hesses
creases94020962c_reases
creeses93914622c_reeses
cresset93319942c_resset
cressets10309102c_ressets
crosses94220792c_rosses
cypresses1645852cypresses
dresses83716172_dresses
duresses939172duresses
egresses949442egresses
farnesses122310812farnesses
harasses11311032harasses
harnesses121812072harnesses
karosses1236492karosses
largesses10246272largesses
ogresses938472ogresses
pareses94718882pare_ses
presses93523152_presses
stresses81112492stresses
tresses73719542_tresses
abbesses1235333abbesses
abysses1234863_abysses
acarboses1345083acarboses
acariases1146613acariases
accessed1385403accessed
acreages1138373acreages
addresses1165633addresses
aggresses1146143aggresses
amasses93912853_amasses
ancresses1138413ancresses
arcuses94814693_arcuses
arenes64928393_are_nes
areoles71016953_areoles
aretes64425353_are_tes
arguses84711743_arguses
arises65233803_ar_ises
arkoses113910833_arkoses
arouses74921293_arouses
arrases71214543_arrases
arrises71617583_arrises
arses55733873_ar__ses
asepses946363_asepses
asses55629283_a__sses
assesses737383assesses
avenses1049643_avenses
badasses1136173badasses
badnesses1239253badnesses
bagasses1136313bagasses
bareges105212033bare_ges
bareness10912813bareness
barenesses12311703barenesses
baronesses1238913baronesses
basses85428303ba__sses
blesses93812393_blesses
boreases10310253boreases
brasses93818353_brasses
brisses94314313_brisses
burgesses1245513burgesses
cabooses1237863cabooses
cabrestas1344013cabrestas
cabrestos1343883cabrestos
cactuses1237933cactuses
caddises12329353caddises
cadelles1139973cadelles
cadences1338473cadences
caesars9410733ca_esars
caestus947773ca_estus
caestuses1144893ca_estuses
caginesses13310943caginesses
cakinesses16310613cakinesses
calashes13310533calashes
caleches15269933caleches
calesas9411833cale_sas
calloses10313393calloses
calluses1039323calluses
calmnesses1436843calmnesses
camases114216343ca_mases
camises114218463ca_mises
campuses1437773campuses
canonesses1238423canonesses
canvases13349523canvases
canvasses14286043canvasses
capiases1239253capiases
carafes125015703car_afes
carassow1343253carassow
carassows1442933carassows
carates95630613car_ates
carbides133111693carbides
carbines123617533carbines
carcase11312743carcase_
carcass11310513carcas_s
cardcases1446503cardcases
careen84119493care__en
careened1139193careened
careener1039333careener
careeners1138543careeners
careens94514703care_ens
career85822243care__er
careered1139493careered
careerer1038583careerer
careerers1137243careerers
careers95218783care_ers
carefree1346343carefree
carers85133963care__rs
cares77369183car___es
caressing1238803caressing
caressive1445823caressive
caretakes1547143caretakes
carets85330773care__ts
carfares13310323carfares
cargoes104415223car_goes
caribes113715643car_ibes
carices114220953car_ices
caries85147623car__ies
carioles10817073carioles
caritases1139753caritases
carles85435083car__les
carless95118493carles_s
carlines103521643carlines
carmines123617863carmines
carnages11312213carnages
carnies94123963car_nies
caroches15710693caroches
caroluses1157613caroluses
carouse9614423carouse_
caroused1149253caroused
carousel1057313carousel
carousels1165343carousels
carouser1068853carouser
carousers1156743carousers
carries94328013car_ries
carse74934333car__se_
cartages11313313cartages
cartelises1247683cartelises
cartes86239473car__tes
carves115128453car__ves
carwashes1745773carwashes
caryopses1645043caryopses
casease939323casease_
caseates10313713caseates
casefies1339213casefies
caseose939163caseose_
casernes103810753casernes
cases75048383ca___ses
casettes1039653casettes
cashes114729883ca__shes
cassenes103611293cassenes
cassis84818853ca__ssis
cassises103811743cassises
castes85631863ca__stes
cateress102311613cateress
caucuses1236783caucuses
caucusses1343043caucusses
causes88026473ca__uses
cayennes1345013cayennes
cayuses12188403ca_yuses
ceases84427073c__eases
celestes10310013celestes
censes83721803c__enses
cerastes101111093cerastes
cercises12410933cercises
cerises94722253cer_ises
ceruses93716233cer_uses
cessed94615613c__essed
charases131312763char_ases
charinesses1639563charinesses
charmeuses1743093charmeuses
chasses124017503c_hasses
chausses1345963chausses
cheeses123613103c_heeses
chorusses1444883chorusses
circuses1238253circuses
clarences1346453clarences
classes94717943c_lasses
clearnesses13106153clearnesses
coalesces1346043coalesces
coatdresses1443943coatdresses
colessee1098793colessee
colessees11146053colessees
coleuses1039723coleuses
compresses1647773compresses
confesses1438623confesses
congresses1348023congresses
cordlesses1346303cordlesses
coreless103013833coreless
cornuses10310033cornuses
corpses113913803cor_pses
corpuses12310063corpuses
corses84433463cor__ses
coynesses1437573coynesses
crases85532313c_r_ases
crashes124618403c_rashes
crasser94114343c_rasser
crassest103411523c_rassest
crease85519573c_rease_
creased104315583c_reased
creaser94415743c_reaser
creasers103612843c_reasers
creates95225203c_reates
creches14313093c_reches
creese84014333c_reese_
creeshes1336953creeshes
cremes104517993c_re_mes
creoles9913323c_reoles
crepes105419343c_re_pes
cresols939653c_resols
cress75022833c_re_s_s
cressy11439113c_ress_y
crested103416533c_rested
crests85218703c_re_sts
cresyls1234753c_resyls
crevasses1444143c_revasses
crises84529433c_r_ises
crosse85216303c_rosse_
crossed105313893c_rossed
crosser95015463c_rosser
crossers103912703c_rossers
crossest1012012123c_rossest
cruises93514443c_ruises
cruses88127713c_r_uses
crushes124215133c_rushes
cuirasses1144373cuirasses
cuisses9319883c_uisses
cureless10319703cureless
curettes1039313curettes
curses85328273cur__ses
curtesies1147523curtesies
curtnesses1238373curtnesses
curtsies1038733curtsies
cusses84522773c__usses
cyeses11510123c_ye_ses
cypreses1535143cypre_ses
czardases2143033czardases
darknesses1537013darknesses
dearnesses1139583dearnesses
depresses1259883depresses
digresses1137863digresses
dressed93511873_dressed
dresser83611953_dresser
dressers9359863_dressers
drosses84513823_drosses
egressed1046873egressed
eldresses1045673eldresses
empresses1348163empresses
esses56422973___esses
excesses1736753excesses
expresses1837863expresses
fairnesses1357383fairnesses
fatnesses121710463fatnesses
fesses94820253__fesses
finesses111912343finesses
foresees11311643foresees
frasses104314513_frasses
freshes133515823_freshes
gasses75724783ga__sses
gausses8308693ga_usses
gaynesses1336563gaynesses
grasses84117343_grasses
greases84816713_greases
grosses84517683_grosses
guesses8169373_guesses
harassed1237113harassed
harasser1137043harasser
harassers1246203harassers
hardasses1346453hardasses
hardnesses141810543hardnesses
harissas1145983harissas
harnessed13186193harnessed
heiresses1236963heiresses
heresies11312693heresies
icinesses11310073icinesses
idlesses936003idlesses
impresses1338213impresses
ingresses1038533ingresses
jesses135215953__jesses
kavasses1544303kavasses
kermesses15284963kermesses
kirmesses15253903kirmesses
lacrosses1145303lacrosses
larees65323113lare__es
largesse9294413largesse_
lasses64827593la__sses
laxnesses1646633laxnesses
loesses7310033_loesses
madnesses1239833madnesses
marishes13512553marishes
marquesses2143353marquesses
marses84827113mar__ses
marshes123615373mar_shes
masses85028713ma__sses
matrasses1157293matrasses
mattresses1245433mattresses
mayoresses1543693mayoresses
messes84924343__messes
morasses1038903morasses
narcoses103910543narcoses
nearnesses1039103nearnesses
nesses64718323__nesses
obsesses1036223obsesses
oppresses1346873oppresses
oratresses1045493oratresses
oyesses1037333_oyesses
paresis93315093pare_sis
parises94827183par_ises
parishes13314753parishes
parses85534703par__ses
parvises133911913parvises
passes86030473pa__sses
patnesses111611793patnesses
pavisses13397103pavisses
peeresses1138473peeresses
pressed103317313_pressed
presser93717623_presser
pressers103215023_pressers
prisses94816713_prisses
prosses94019513_prosses
rarefies1138993rarefies
rareness81112853rareness
rarenesses10313113rarenesses
rawnesses1288123rawnesses
recesses10312323recesses
redresses10410293redresses
regresses10310463regresses
represses11412143represses
resees63827483__resees
reshes94124363__reshes
reuses66025523__reuses
sadnesses10310303sadnesses
sarees65329943sare__es
saroses73619333sar_oses
sasses64124393sa__sses
scarinesses1339903scarinesses
seeresses939053seeresses
strasses81311443strasses
stressed9128543stressed
tartnesses101110713tartnesses
tasses64826763ta__sses
threshes1437383threshes
tigresses1046403tigresses
trasses74819323_trasses
tressed83714263_tressed
tressel73010893_tressel
tressels8367653_tressels
trusses73813643_trusses
undresses1039313undresses
uraeuses835383uraeuses
ureases74416723_ureases
varuses10310623var_uses
victresses1544973victresses
vitesses1136333vitesses
votaresses1343913votaresses
votresses1236503votresses
waenesses1239773waenesses
waitresses1345063waitresses
wannesses1239233wannesses
wardresses1445413wardresses
warinesses131514523warinesses
warmnesses15167353warmnesses
warsles103413643war_sles
wrasses103812593_wrasses
yesses93615813__yesses

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.423422437.4
2DLD Change Limit1461623807.84318636.0
3Display Results3803800.1562435.9
 (SQL Overall)1786913808.42221217.2
 
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.