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

270 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
caret7536056(None) 
cadet85339341cadet
carat75048791carat
care66968371care_
cared86050091cared
carer74942331carer
cares77369181cares
carets85330771carets
carex144822301carex
carnet84732871carnet
carpet104530091carpet
cart66570341car_t
carte75940421carte
claret84026571claret
curet75447641curet
abet610547942_abet
acre67330772acre_
acred87126352acred
acres76327762acres
are37874572_are_
area45843392_area
ares45871022_ares
arete56031352_arete
armet76739452_armet
art38679142_ar_t
barbet104427882barbet
bare65460522bare_
bared85144482bared
barer74535802barer
bares75457132bares
barest85327692barest
barret84930482barret
beret74946362beret
buret77444012buret
cabaret112519042cabaret
caber95126832caber
cablet104429462cablet
cachet134526412cachet
cade76443912cade_
cadent94120362cadent
cades85440732cades
cadets96316512cadets
cadre85419022cadre_
cadres94017932cadres
cafe95230322cafe_
cafes106426922cafes
cage75339062cage_
caged95426362caged
cager85229222cager
cages85936012cages
cagey115917822cagey
cake105439962cake_
caked126128622caked
cakes116037672cakes
cakey145517272cakey
callet84536762callet
came87648752came_
camel96822802camel
cameo95924992cameo
cames97047312cames
camlet104426582camlet
cane66653122cane_
caned85838092caned
caner75334772caner
canes75350372canes
canst74932212canst
cant66362032ca_nt
cape87242782cape_
caped104931802caped
caper94831622caper
capes95441922capes
caplet104226812caplet
caput9823982caput
car59165562car__
carate84734002carate
carats85929022carats
carb85143162car_b
carbo94923842carbo
carbs96031462carbs
carcel105018672carcel
card710245872car_d
carded105424902carded
carder94524182carder
cards85137932cards
careen84119492careen
career85822242career
carers85133962carers
caress85720262caress
cargo85322072cargo
caried94528692caried
caries85147622caries
cark105539272car_k
carked134024822carked
carks115534212carks
carl65144782car_l
carle74535702carle
carles85435082carles
carls77037422carls
carmen104019342carmen
carn66245432car_n
carnets93918402carnets
carney115315702carney
carns75937562carns
carny105822922carny
carob95325222carob
carol75128612carol
carom95025562carom
carp85139812car_p
carped115923762carped
carpel105418472carpel
carper104923632carper
carpets113915332carpets
carpi94319392carpi
carps96932252carps
carr65434702car_r
carrel84718632carrel
carrot8423122carrot
carrs75730852carrs
carry105823782carry
cars67364762car_s
carse74934332carse
carses85233652carses
carted98631442carted
cartel85022532cartel
carter84932272carter
cartes86239472cartes
carts78946292carts
carve106227752carve
carved124320852carved
carvel114817572carvel
carven114716662carven
carver114420142carver
carves115128452carves
case65848082case_
cased86032412cased
cases75048382cases
casket124820992casket
cast67159902ca_st
caste75932362caste
cat58282342ca__t
cate66254602cate_
cater74840722cater
cates75951892cates
cave95941262cave_
caveat11417722caveat
caved116227562caved
caver105629062caver
caves105639702caves
cawed116627062cawed
cere66741472cere_
cered85227442cered
ceres75540012ceres
cermet10321152cermet
chalet113825992chalet
chare105231982chare_
chared125423692chared
chares115631802chares
chart105038282char_t
chert105232102chert
cigaret10413002cigaret
cire65836372cire_
cires74932912cires
civet105828732civet
clarets94111102clarets
comet95946072comet
core67263112core_
cored85044222cored
corer75538872corer
cores76361852cores
cornet84436732cornet
corset85636222corset
corvet114626932corvet
coset75748842coset
covet105638942covet
craft105327662craft
crate76537402crate
cred76530882c_red
crept95125892c_rept
crest74632692c_rest
crew96122672c_rew
crit65743712c_rit
cruet74831842cruet
culet76040342culet
cure66149122cure_
cured85932132cured
curer75030752curer
cures75645432cures
curets84922342curets
curst74931022curst
curt67051712cur_t
curvet114720242curvet
dare55848862dare_
dared75935012dared
darer65230792darer
dares66146702dares
dart55857872dar_t
eared65139502eared
ecarte84313502ecarte
egret63327312egret
facet106038522facet
fare76354462fare_
fared95842342fared
farer86733142farer
fares85852872fares
fart76860562far_t
fret75845042_fret
garget84327272garget
garnet73928412garnet
garret74426552garret
haet75659502ha_et
hare76255732hare_
hared95742182hared
harem104924452harem
hares86255542hares
hart76865772har_t
imaret81121232imaret
karat96837592karat
karst97228992karst
kart86750802kar_t
labret8320222labret
laree56036292laree
lares54852632lares
mare64759332mare_
mares76457632mares
market123226042market
mart66865982mar_t
nares55544152nares
oared65030652oared
palet74650802palet
pare66760842pare_
pared86946762pared
parent83230422parent
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
parget94529392parget
part65967462par_t
ramet75743142ramet
rare45348432rare_
rared65738322rared
rarer54731702rarer
rares55247442rares
rarest65725482rarest
ret35982832__ret
saree55044662saree
scare75334462scare_
scared95227292scared
scarer84524602scarer
scares85033002scares
scarey115016982scarey
scarlet91516942scarlet
scart76139772scar_t
tacet75840022tacet
tare45957622tare_
tared69340052tared
tares57456562tares
target75028902target
tarot55943932tarot
tart47566182tar_t
tret46653532_tret
valet84337872valet
varlet9423502varlet
ware76254722ware_
wared96339872wared
wares88250582wares
wart77866082war_t
yare75636942yare_
yarer84321572yarer
yarest95018912yarest

Search took 2 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 Filter178691538000.0802233637.5
2DLD Change Limit538002701.73331044.4
3Display Results2702700.0803375.0
 (SQL Overall)1786912701.89394395.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.