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

258 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
carle7453570(None) 
cable95329911cable
care66968371car_e
carl65144781carl_
carles85435081carles
carls77037421carls
carse74934331carse
carte75940421carte
carve106227751carve
farle86929241farle
parle75836161parle
able66340532_able
acre67330772acr_e
ale36572342_a_le
are37874572_ar_e
argle65421562_argle
arles56735742_arles
arse46539272_arse
axle116424602_axle
bale66353842ba_le
barbe95328282barbe
barde85330772barde
bare65460522bar_e
barge85631022barge
barley115116762barley
barre75929542barre
barye105021492barye
birle75023632birle
cabled114819872cabled
cabler104519172cabler
cables104527552cables
cablet104429462cablet
cache125122482cache
cackle143416922cackle
cade76443912ca_de
cadge94018792cadge
cadre85419022cadre
cafe95230322ca_fe
cage75339062ca_ge
cajole154011182cajole
cake105439962ca_ke
calf96339562ca_lf
calk105527662ca_lk
call66838672ca_ll
calla74827072calla
called94126732called
callee84327292callee
caller85125482caller
callet84536762callet
calls75634732calls
calm85032362ca_lm
calo64936442ca_lo
calve105919922calve
calx135722792ca_lx
came87648752ca_me
camel96822802camel
camlet104426582camlet
candle94321482candle
cane66653122ca_ne
canoe75627252canoe
cantle84522152cantle
cape87242782ca_pe
caplet104226812caplet
car59165562car__
carafe115416162carafe
carat75048792carat
carate84734002carate
carb85143162car_b
carbo94923842carbo
carbs96031462carbs
carcel105018672carcel
card710245872car_d
carded105424902carded
carder94524182carder
cards85137932cards
cared86050092cared
careen84119492careen
career85822242career
carer74942332carer
cares77369182cares
caret75360562caret
carex144822302carex
cargo85322072cargo
caribe103416752caribe
caried94528692caried
caries85147622caries
cariole9818342cariole
cark105539272car_k
carked134024822carked
carks115534212carks
carless95118492carless
carlin84421822carlin
carline93923612carline
carmen104019342carmen
carn66245432car_n
carnet84732872carnet
carney115315702carney
carnie84421092carnie
carns75937562carns
carny105822922carny
carob95325222carob
carol75128612carol
caroled103717692caroled
caroler93816752caroler
caroli85918232caroli
carols85124982carols
carom95025562carom
carp85139812car_p
carpale113414352carpale
carped115923762carped
carpel105418472carpel
carper104923632carper
carpet104530092carpet
carpi94319392carpi
carps96932252carps
carr65434702car_r
carrel84718632carrel
carrs75730852carrs
carry105823782carry
cars67364762car_s
carses85233652carses
cart66570342car_t
carted98631442carted
cartel85022532cartel
carter84932272carter
cartes86239472cartes
carts78946292carts
carved124320852carved
carvel114817572carvel
carven114716662carven
carver114420152carver
carves115128452carves
case65848082ca_se
caste75932362caste
castle84918962castle
cate66254602ca_te
cattle85118902cattle
caudle93912912caudle
caul65630002caul_
cauld85318442cauld
caules85927252caules
caulk115315452caulk
cauls75727772cauls
cause75225352cause
cave95941262ca_ve
cavie104621592cavie
cere66741472cer_e
chare105231982char_e
charge125114212charge
charley15118272charley
charlie123011922charlie
chile105626892chile
chyle134913482chyle
circle1039702circle
cire65836372cir_e
coarse84813902coarse
coble94823172coble
cole66956112c_ole
core67263112cor_e
corse75036182corse
cradle93313162cradle
crake114823522crake
crane75331602crane
crape96128442crape
crate76537402crate
crave105626312crave
craze165221462craze
curdle95514312curdle
cure66149122cur_e
curie74533042curie
curl66035052curl_
curled95021652curled
curler85221322curler
curlew114010902curlew
curls74927102curls
curly105321232curly
curse75829142curse
curule83614122curule
curve104920022curve
cycle1239522cycle
dale55643982da_le
dare55848862dar_e
darkle113813942darkle
dartle73714832dartle
eagle64219482eagle
earl45838142earl_
earls56127512earls
early85324122early
ecarte84313502ecarte
fable105824752fable
farce104925322farce
fare76354462far_e
farl76338552farl_
farles96025782farles
farls85731112farls
gable85325522gable
gale56347322ga_le
garble94118452garble
gargle84215462gargle
hale76052832ha_le
haole84820082haole
hare76255732har_e
harl75740002harl_
harls85634502harls
jarl115828132jarl_
jarls126120962jarls
kale86533752ka_le
ladle66320442ladle
laree56036292laree
large65325462large
macle96127002macle
maile75232222maile
male66052302ma_le
maple95521142maple
marble104219102marble
mare64759332mar_e
marge85328332marge
marl66341622marl_
marled95523162marled
marls75535162marls
marly106925612marly
marse76231152marse
merle75824372merle
orle45630462_orle
padle84522342padle
pale66055012pa_le
parae76335702parae
pare66760842par_e
parge85831852parge
parled94626292parled
parles86334402parles
parley116718362parley
parole84425252parole
parse75236992parse
parve109824852parve
rale45050562ra_le
rare45348432rar_e
sable74732162sable
sale44959702sa_le
saree55044662saree
sarge65531132sarge
scale74629142sca_le
scarce104013632scarce
scare75334462scar_e
scarlet91516942scarlet
table75429602table
tale46154162ta_le
tare45957622tar_e
targe65227092targe
tarre55825632tarre
vale74937342va_le
varlet9423502varlet
varve115716852varve
wale74546432wa_le
warble113516602warble
ware76254722war_e
warsle93112922warsle
yare75636942yar_e

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.313570897.8
2DLD Change Limit538002581.48336277.8
3Display Results2582580.0634095.2
 (SQL Overall)1786912581.85996122.1
 
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.