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

487 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
cared8605009(None) 
acred87126351acred
bared85144481bared
caged95426361caged
caked126128621caked
caned85838091caned
caped104931801caped
card710245871car_d
carded105424901carded
care66968371care_
carer74942331carer
cares77369181cares
caret75360561caret
carex144822291carex
caried94528691caried
carked134024821carked
carped115923761carped
carted98631441carted
carved124320851carved
cased86032411cased
caved116227561caved
cawed116627061cawed
cered85227441cered
chared125423691chared
cored85044221cored
cred76530881c_red
cured85932131cured
dared75935011dared
eared65139501eared
fared95842341fared
hared95742181hared
oared65030651oared
pared86946761pared
rared65738321rared
scared95227291scared
tared69340051tared
wared96339871wared
aahed917816442aahed
abed79734132_abed
acarid95017062acarid
aced79540882_aced
ached119227832ached
acned87520662acned
acre67330772acre_
acres76327762acres
acrid86920102acrid
acted88521732acted
aged67334252_aged
ahed89536252_ahed
aired66032922aired
aped78538152_aped
arced88224162_arced
are37874572_are_
area45843392_area
ares45871022_ares
arid57642712_arid
armed86324432_armed
ascared10399522ascared
awed88436032_awed
axed128829612_axed
baaed85218162baaed
baked126130772baked
baled85436442baled
baned85436352baned
barbed115121312barbed
bard75648862bar_d
barde85330772barde
barded105426422barded
bare65460522bare_
barer74535802barer
bares75457132bares
barfed125416382barfed
barged105822642barged
barked135027312barked
barned95623582barned
barred95725792barred
based85331582based
bated85935532bated
bayed115423022bayed
blared95018242blared
bored85034302bored
bred75130972_bred
cabbed135416262cabbed
caber95126832caber
cabled114819872cabled
cached145419202cached
cad67456362ca__d
cade76443912cade_
cades85440732cades
cadet85339332cadet
cadged114812332cadged
cadre85419012cadre_
cadres94017922cadres
cafe95230322cafe_
cafes106426922cafes
cage75339062cage_
cager85229222cager
cages85936012cages
cagey115917822cagey
caid77837532ca_id
caird85717232caird
cairned1037642cairned
cake105439962cake_
cakes116037672cakes
cakey145517272cakey
calked134617402calked
called94126732called
calmed114816382calmed
calved125215452calved
came87648752came_
camel96822802camel
cameo95924992cameo
cames97047312cames
camped134720232camped
cane66653112cane_
caner75334772caner
canes75350372canes
canid85526342canid
canned95022062canned
canoed94618952canoed
canted94825782canted
cape87242782cape_
caper94831622caper
capered123014042capered
capes95441922capes
capped134721852capped
car59165562car__
carat75048792carat
carb85143162car_b
carbo94923842carbo
carbs96031462carbs
carcel105018672carcel
carder94524182carder
cards85137932cards
careen84119492careen
career85822242career
carers85133952carers
caress85720262caress
carets85330772carets
cargo85322072cargo
caries85147622caries
cark105539272car_k
carks115534212carks
carl65144782car_l
carle74535702carle
carles85435082carles
carls77037422carls
carmen104019342carmen
carn66245432car_n
carnet84732872carnet
carney115315702carney
carns75937562carns
carny105822922carny
carob95325222carob
carol75128612carol
caroled103717682caroled
carom95025562carom
caromed123713622caromed
carp85139812car_p
carpel105418472carpel
carper104923632carper
carpet104530092carpet
carpi94319392carpi
carps96932252carps
carr65434702car_r
carrel84718632carrel
carried103717152carried
carrs75730852carrs
carry105823782carry
cars67364762car_s
carse74934332carse
carses85233652carses
cart66570342car_t
carte75940422carte
cartel85022532cartel
carter84932272carter
cartes86239472cartes
carts78946292carts
carve106227752carve
carvel114817572carvel
carven114716662carven
carver114420142carver
carves115128452carves
case65848082case_
cases75048382cases
cashed125124352cashed
casked134815512casked
cate66254592cate_
cater74840702cater
catered103117762catered
cates75951872cates
catted95422472catted
cauld85318442cauld
caused95117042caused
cave95941262cave_
caver105629062caver
caves105639702caves
ceased94920782ceased
ceded96118552ceded
cere66741472cere_
ceres75540012ceres
chafed154813912chafed
chaired134211242chaired
chard116124742char_d
chare105231982chare_
chares115631802chares
charged144614022charged
charked174814012charked
charmed154714242charmed
charred134614482charred
charted135116852charted
chased125019292chased
chawed155214602chawed
chored125321882chored
cire65836372cire_
cires74932912cires
cited84421952cited
claret84026572claret
clawed125115072clawed
clayed125013042clayed
cleared103612462cleared
clued84917682clued
coaled95022702coaled
coated94927032coated
coaxed165612512coaxed
coded95433182coded
coed77140542c_oed
coked124730692coked
coled85540752coled
coned86040052coned
cooed84534342cooed
coped105036842coped
cord76740922cor_d
corded105923352corded
core67263112core_
corer75538872corer
cores76361852cores
corked135020782corked
corned95224522corned
coted85033852coted
coved115027372coved
cowed115637842cowed
coxed154322812coxed
coyed114623802coyed
craned96121652craned
craped116120522craped
crated94827772crated
craved125417772craved
crazed184714452crazed
credo84815562c_redo
creds85418772c_reds
creed85727392creed
crew96122672c_rew
cried84624282cried
crud75219612c_rud
cubed105519702cubed
cued76329562c_ued
curbed114615872curbed
curd77634982cur_d
curded104217162curded
cure66149122cure_
curer75030752curer
cures75645432cures
curet75447642curet
curled95021652curled
curred94319262curred
cursed94321252cursed
curved124815222curved
dare55848862dare_
darer65230792darer
dares66146702dares
darked123919632darked
darned85018482darned
darted84620922darted
dated75530992dated
dawed106222812dawed
dazed165919362dazed
dured75025402dured
earned74818332earned
eased65430402eased
eaved95924502eaved
erred65915672erred
faced117727652faced
faded105025242faded
faired105915772faired
faked135225482faked
famed115928342famed
farad95720672farad
farced125216532farced
fard85639062far_d
farded114518952farded
fare76354462fare_
farer86733142farer
fares85852872fares
farmed125117652farmed
farted105121782farted
fated95632132fated
faxed166220532faxed
fayed126422152fayed
fazed186222962fazed
feared106320432feared
fired94829742fired
flared105317602flared
gaed66031512ga_ed
gaged85522312gaged
gamed95126392gamed
gaped96123532gaped
garbed104815662garbed
garred85217402garred
gated75329772gated
gazed165520332gazed
geared85317742geared
glared84715192glared
gored75227082gored
gyred105114092gyred
haded105227622haded
haed86338582ha_ed
haired105117172haired
haled95335822haled
hard85443502har_d
hare76255732hare_
harem104924452harem
hares86255542hares
harked145422552harked
harmed125218832harmed
harped124418402harped
hated95734022hated
hatred104814332hatred
hawed126025422hawed
hayed125822012hayed
hazed185222202hazed
hired95226262hired
ired55131872_ired
jaded144417032jaded
japed156217632japed
jarred144613252jarred
jawed165517372jawed
laced87132642laced
laded74232612laded
laired75216812laired
laked105731122laked
lamed85235292lamed
lard56742002lar_d
larded84319092larded
laree56036292laree
lares54852632lares
larked114519472larked
lased65132342lased
lated65240672lated
laved95028592laved
lawed96028322lawed
layed95127382layed
lazed154925842lazed
lured65427492lured
maced108528692maced
maned86634092maned
mare64759322mare_
mares76457632mares
marked133921622marked
marled95523162marled
marred95421042marred
marted94425212marted
mated85537782mated
mawed115824742mawed
maxed155821192maxed
mayed115522402mayed
mazed175523872mazed
mired85729222mired
mured85726702mured
nacred95212492nacred
naked105320852naked
naled65525052naled
named85223062named
nard56634452nar_d
nares55544152nares
narked114116742narked
neared75119802neared
ochred12328002ochred
paced106931682paced
paged95926782paged
paired95017522paired
paled85538722paled
paned85437182paned
pard76441322par_d
pare66760842pare_
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
parged104922032parged
parked134425132parked
parled94626272parled
parred95024072parred
parsed96323892parsed
parted94228682parted
pated85237842pated
paved115525262paved
pawed115725612pawed
payed115925932payed
pored85234512pored
raced87635312raced
raged74829452raged
raked105831422raked
raped85334622raped
rare45348432rare_
rarer54731702rarer
rares55247442rares
rased65033932rased
rated65441382rated
raved94931432raved
raxed135622662raxed
rayed95127502rayed
razed155027982razed
reared75930012reared
red46755802__red
roared75015392roared
sabed86526812sabed
sabred95916532sabred
sacred94917102sacred
saned65636272saned
sard55344242sar_d
saree55044662saree
sarod65325872sarod
sated66238532sated
saved95127112saved
sawed95628402sawed
sayed96127142sayed
scaled94822442scaled
scaped115519552scaped
scare75334462scare_
scarer84524602scarer
scares85033002scares
scarey115016982scarey
scarfed134711182scarfed
scarped124314392scarped
scarred104512632scarred
scarted104816122scarted
scored94621132scored
seared75232842seared
sered65737292sered
shared105829062shared
shred98125612shred
sired66134282sired
snared74824552snared
soared74324292soared
sored66141782sored
spared95427482spared
stared75429872stared
tamed85528512tamed
taped85327422taped
tare45957622tare_
tares57456562tares
tarred74720282tarred
tarted74923372tarted
tawed95926192tawed
taxed135620292taxed
teared75722152teared
tired65228902tired
tyred95816432tyred
vaned94622422vaned
varied104817862varied
varved134110602varved
waded106024752waded
waged104822782waged
waired106015832waired
waked135626752waked
waled94330992waled
waned95831782waned
ward86542252war_d
warded115021042warded
ware76254722ware_
wares88250582wares
warked144421212warked
warmed124516892warmed
warned104018912warned
warped124816412warped
warred104019842warred
warted104223232warted
waved125223582waved
waxed166018482waxed
wired95327642wired
yard85633252yar_d
yarded114714022yarded
yare75636942yare_
yarer84321572yarer
yarned105514022yarned
yawed126022452yawed

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 Filter178691538000.1061685764.2
2DLD Change Limit538004871.95627505.1
3Display Results4874870.1403478.6
 (SQL Overall)1786914872.20281149.4
 
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.