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

289 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
carse7493433(None) 
arse46539271_arse
care66968371car_e
cares77369181cares
carle74535701carle
cars67364761cars_
carses85233651carses
carte75940421carte
carve106227751carve
case65848081ca_se
cause75225351cause
coarse84813891coarse
corse75036181corse
curse75829141curse
marse76231151marse
parse75236991parse
acre67330772acr_e
acres76327762acres
apse67725382_apse
are37874572_ar_e
ares45871022_ares
arise56436432_arise
arose55832082_arose
ars37670932_ars_
arses55733872_arses
barbe95328282barbe
barde85330772barde
bare65460522bar_e
bares75457132bares
barge85631022barge
barre75929542barre
bars66564092bars_
barye105021492barye
base64847022ba_se
birse74517402birse
burse75527252burse
cable95329912cable
cabs86739422cabs_
cache125122482cache
cade76443912ca_de
cades85440732cades
cadge94018782cadge
cadre85419012cadre
cadres94017922cadres
cads76144522cads_
cafe95230322ca_fe
cafes106426922cafes
cage75339062ca_ge
cages85936012cages
cake105439962ca_ke
cakes116037672cakes
calve105919922calve
came87648752ca_me
cames97047312cames
camise103319632camise
cams87047282cams_
cane66653112ca_ne
canes75350372canes
canoe75627252canoe
cans65050842cans_
canso75019402canso
canst74932212canst
cape87242782ca_pe
capes95441922capes
caps87147892caps_
car59165562car__
carafe115416162carafe
carat75048792carat
carate84734002carate
carb85143162car_b
carbo94923842carbo
carbs96031462carbs
carcase11312732carcase
carcel105018672carcel
card710245872car_d
carded105424902carded
carder94524182carder
cards85137932cards
cared86050092cared
careen84119492careen
career85822242career
carer74942332carer
caress85720262caress
caret75360562caret
carex144822292carex
cargo85322072cargo
caribe103416752caribe
caried94528692caried
caries85147622caries
cark105539272car_k
carked134024822carked
carks115534212carks
carl65144782car_l
carles85435082carles
carls77037422carls
carmen104019342carmen
carn66245432car_n
carnet84732872carnet
carney115315702carney
carnie84421092carnie
carns75937562carns
carny105822922carny
carob95325222carob
carol75128612carol
carom95025562carom
carouse9614422carouse
carp85139812car_p
carped115923762carped
carpel105418472carpel
carper104923632carper
carpet104530092carpet
carpi94319392carpi
carps96932252carps
carr65434702car_r
carrel84718632carrel
carrs75730852carrs
carry105823782carry
cart66570342car_t
carted98631442carted
cartel85022532cartel
carter84932272carter
cartes86239472cartes
carts78946292carts
carved124320852carved
carvel114817572carvel
carven114716662carven
carver114420142carver
carves115128452carves
casa65630862ca_sa
cased86032412ca_sed
cases75048382ca_ses
cash96636282ca_sh
cask105626432ca_sk
cast67159902ca_st
caste75932362caste
cate66254592ca_te
cates75951872cates
cats66356342cats_
caused95117042caused
causer84117782causer
causes88026472causes
causey113513272causey
cave95941262ca_ve
caves105639702caves
cavie104621592cavie
caws96036102caws_
cays95437672cays_
cayuse11207762cayuse
cease75227652cease
cense75121402cense
cere66741472cer_e
ceres75540012ceres
cerise84822042cerise
ceruse83914522ceruse
chaise114916412chaise
chare105231982char_e
chares115631802chares
charge125114212charge
chars105936632chars_
chase105127122chase
chasse115114602chasse
chose105925402chose
cire65836372cir_e
cires74932912cires
clause84311502clause
close76425222close
coarsen93210322coarsen
coarser93211192coarser
copse95623922copse
core67263112cor_e
cores76361852cores
corpse104013402corpse
cors66656442cors_
corses84433462corses
corset85636222corset
course85117772course
crake114823522crake
crane75331602crane
crape96128442crape
crases85532312crases
crash109120012crash
crass76328042crass
crate76537402crate
crave105626312crave
craze165221462craze
cruse75726102cruse
cure66149122cur_e
cures75645432cures
curie74533032curie
curs65645542curs_
cursed94321252cursed
curser84721472curser
curses85328272curses
curst74931022curst
curve104920022curve
czars164812912czars_
dare55848862dar_e
dares66146702dares
ears46356592ears_
ease45042332ea_se
ecarte84313502ecarte
erase54925492erase
false84818122false
farce104925322farce
fare76354462far_e
fares85852872fares
farle86929242farle
gars55750742gars_
gorse65926812gorse
hanse85722792hanse
hare76255732har_e
hares86255542hares
harsh116418052harsh
hawse116015122hawse
hearse94114272hearse
hoarse94411322hoarse
horse86132652horse
jars117338352jars_
karst97228992karst
lapse74917682lapse
laree56036292laree
lares54852632lares
large65325462large
lars46956572lars_
lase46148512la_se
manse75528222manse
mare64759322mar_e
mares76457632mares
marge85328332marge
mars66261862mars_
marses84827112marses
marsh105320852marsh
masse75125292masse
morse76032702morse
nares55544152nares
nurse54420122nurse
oars46846032oars_
paise75028332paise
parae76335702parae
pare66760842par_e
pares77164482pares
parge85831852parge
parle75836162parle
pars67560792pars_
parsec105914472parsec
parsed96323892parsed
parser84822372parser
parses85534702parses
parve109824852parve
pase65346862pa_se
passe75525692passe
pause75021832pause
perse75429522perse
prase76128752prase
purse76028892purse
raise54828052raise
rare45348432rar_e
rares55247442rares
rase46149982ra_se
saree55044662saree
sarge65531132sarge
sarsen6314232sarsen
scarce104013632scarce
scare75334462scar_e
scares85033002scares
scars75433532scars_
sparse84516342sparse
tare45957622tar_e
tares57456562tares
targe65227092targe
tarre55825632tarre
tars46763952tars_
tarsi55222172tarsi
tasse54821842tasse
tawse85616502tawse
terse55026822terse
torse55833332torse
urase54624682urase
valse85117522valse
vars75742072vars_
varve115716852varve
vase75629652va_se
verse84723582verse
ware76254722war_e
wares88250582wares
wars78659802wars_
warsle93112922warsle
worse86525262worse
yare75636942yar_e

Search took 4 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.190940478.9
2DLD Change Limit538002892.70319903.8
3Display Results2892890.1531888.9
 (SQL Overall)1786912893.04658664.1
 
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.