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 “cartes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

285 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
cartes8623947(None) 
carates95630611carates
cares77369181car_es
carets85330771carets
caries85147621caries
carles85435081carles
carses85233651carses
carte75940421carte_
carted98631441carted
cartel85022531cartel
cartels94618121cartels
carter84932271carter
carters95327251carters
carts78946291cart_s
carves115128451carves
castes85631861castes
cates75951891ca_tes
certes84623081certes
crates85736061crates
ecartes94212561ecartes
acres76327762acr_es
acutes83917722acutes
antes56334322_antes
ares45871022_ar_es
aretes64425352_aretes
arles56735742_arles
arses55733872_arses
artel56122742_artel
artels66216232_artels
arts49650262_art_s
ates45047922_a_tes
barbes104526232barbes
bardes95026932bardes
bares75457132bar_es
barges94528252barges
barites94322332barites
barres84427552barres
barter85525382barter
barters94223042barters
baryes116218502baryes
barytes124611152barytes
bastes85330382bastes
bates75846342ba_tes
cables104527552cables
caches137926912caches
cactus104912232cactus
cades85440732ca_des
cadets96316512cadets
cadges104716712cadges
cadres94017932cadres
cafes106426922ca_fes
cages85936012ca_ges
cakes116037672ca_kes
calces104420052calces
calves115119282calves
calxes154113032calxes
cames97047312ca_mes
canes75350372ca_nes
canoes84725882canoes
canted94825782canted
canter85230112canter
canters94827732canters
cantles94721412cantles
cantos84826972cantos
cants77036942cant_s
cantus85117762cantus
capes95441922ca_pes
capotes11314642capotes
carafes125015702carafes
carate84734002carate_
carats85929022carats
carbos105122262carbos
carbs96031462car_bs
carcel105018672carcel
carcels114516062carcels
carded105424902carded
carder94524182carder
carders104820352carders
cards85137932car_ds
care66968372car_e_
cared86050092car_ed
careen84119492careen
careens94514702careens
career85822242career
careers95218782careers
carer74942332car_er
carers85133962carers
caress85720262caress
caret75360562car_et
carex144822302car_ex
cargoes104415222cargoes
cargos94619182cargos
caribes113715642caribes
carices114220952carices
caried94528692caried
caritas93316962caritas
carked134024822carked
carks115534212car_ks
carle74535702carle_
carless95118492carless
carls77037422car_ls
carmen104019342carmen
carnet84732872carnet
carnets93918402carnets
carney115315702carney
carneys124310542carneys
carnies94123962carnies
carns75937562car_ns
carobs104818102carobs
carols85124982carols
caroms105619572caroms
carped115923762carped
carpel105418472carpel
carpels115315462carpels
carper104923632carper
carpers114521252carpers
carpet104530092carpet
carpets113915332carpets
carps96932252car_ps
carpus105514302carpus
carrel84718632carrel
carrels95117302carrels
carries94328012carries
carrs75730852car_rs
cars67364762car__s
carse74934332carse_
cart66570342cart__
cartages11313312cartages
carton84522662carton
cartons94122472cartons
cartop104213562cartop
carve106227752carve_
carved124320852carved
carvel114817572carvel
carvels124914592carvels
carven114716662carven
carver114420152carver
carvers124817542carvers
cases75048382ca_ses
cashes114729882cashes
caste75932362caste_
caster85232572caster
casters94729902casters
castles94917732castles
casts77237792cast_s
cate66254602ca_te_
cater74840722ca_ter
caters85336502ca_ters
cats66356342ca_t_s
catted95422472catted
catties94023052catties
caules85927252caules
causes88026472causes
caves105639702ca_ves
cavies114525002cavies
cerates95428252cerates
ceres75540012cer_es
cerites94823432cerites
cetes75731102c_etes
chares115631802char_es
charges134615982charges
charted135116852charted
charter123918302charter
charters134115582charters
charts115823092chart_s
chutes114615772chutes
cires74932912cir_es
cites74435592c_ites
clarets94111102clarets
claries93422202claries
claroes93113742claroes
comtes106222812comtes
contes84432912contes
cores76361852cor_es
corses84433462corses
cortex15311472cortex
corves115122522corves
cotes76347842c_otes
crakes124921812crakes
cranes84330752cranes
crapes104727692crapes
crases85532312crases
crate76537402crate_
crated94827772crated
crater85026642crater
craters95021892craters
craves115825392craves
crazes174720132crazes
cries75438402c_ries
curates95323832curates
cures75645432cur_es
curets84922342curets
curies84934022curies
curites93919862curites
curses85328272curses
curter85320082curter
curtest9713962curtest
curtesy1265832curtesy
curves114619282curves
cutes79438322c_utes
dares66146702dar_es
darted84620922darted
darter75320362darter
darters84017602darters
dartles84014132dartles
darts67635732dart_s
dates65639152da_tes
earths95014592earths
ecarte84313502ecarte_
farces115223322farces
fares85852872far_es
farles96025782farles
farted105121782farted
farts88336842fart_s
fates85139232fa_tes
fortes95327182fortes
garotes8614572garotes
garter74420512garter
garters84218242garters
garths104111502garths
gates65939512ga_tes
grates75429892grates
hares86255542har_es
harts88441592hart_s
hastes95727072hastes
hates86742572ha_tes
karates115617472karates
karts97630112kart_s
larees65323112larees
lares54852632lar_es
larges74824232larges
lattes65324202lattes
mantes84430782mantes
mares76457632mar_es
marges94525712marges
marses84827112marses
marted94425212marted
marten84518262marten
martens93714952martens
marts77442232mart_s
mates75251362ma_tes
matres84522232matres
mattes85624532mattes
nares55544152nar_es
nates55238332na_tes
orates64328612orates
pares77164482par_es
parges94529542parges
paries84742512paries
parles86334402parles
parses85534702parses
parted94228682parted
parties93230862parties
parts77743372part_s
pastes85233912pastes
pates76047892pa_tes
prates84633162prates
quartes163314932quartes
rares55247442rar_es
rates55352012ra_tes
sarees65329942sarees
sarges75128592sarges
sates54949322sa_tes
sautes63924912sautes
scares85033002scar_es
scarted104816122scarted
scarts85321492scart_s
scarves124511622scarves
tares57456562tar_es
targes74524602targes
tarres64723042tarres
tarted74923372tarted
tarter64023562tarter
tartest72517532tartest
tarts57242022tart_s
tastes64126422tastes
tates55444982ta_tes
tortes64826052tortes
urates65027762urates
varies94330872varies
varves124414782varves
wares88250582war_es
warted104223232warted
warts814840402wart_s
wastes96224882wastes

Search took 3 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 Filter178691825510.326548131.9
2DLD Change Limit825512852.31335690.0
3Display Results2852850.0933064.5
 (SQL Overall)1786912852.73265406.7
 
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.