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

315 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
carr6543470(None) 
car59165561ca_r
carb85143161carb
card710245871card
care66968371care
carer74942331carer
cark105539271cark
carl65144781carl
carn66245431carn
carp85139811carp
carrs75730851carrs
carry105823781carry
cars67364761cars
cart66570341cart
charr104821781charr
curr65429651curr
parr65731151parr
acari75020282acari
acre67330772acre
air38058392_air
ar211379382_a_r
arb510448422_arb
arc510250902_arc
are37874572_are
arf67453372_arf
ark77044962_ark
arm58449622_arm
ars37670932_ars
art38679142_art
bar58070552ba_r
barb85240062barb
bard75648862bard
bare65460522bare
barer74535802barer
barf95844402barf
bark106242152bark
barm86739602barm
barn66444642barn
barre75929542barre
bars66564092bars
birr66022352birr
brr56921922_brr
brrr65312292brrr
burr65631232burr
cab78355402ca_b
caber95126832caber
cabs86739422cabs
caca85528082caca
cad67456362ca_d
cade76443912cade
cadi75732172cadi
cadre85419012cadre
cads76144522cads
cafe95230322cafe
caff125631672caff
cage75339062cage
cager85229222cager
cagy106321992cagy
caid77837532caid
cain65643912cain
caird85717232caird
cairn75717512cairn
cake105439962cake
caky136222442caky
calf96339562calf
calk105527662calk
call66838672call
calm85032362calm
calo64936442calo
calx135722792calx
cam78058982ca_m
came87648752came
camo85731752camo
camp106336452camp
cams87047282cams
can57760132ca_n
cane66653112cane
caner75334772caner
cans65050842cans
cant66362022cant
cap76758982ca_p
cape87242782cape
caper94831622caper
caph116623292caph
capo85829212capo
caps87147892caps
carat75048792carat
carbo94923842carbo
carbs96031462carbs
carder94524182carder
cards85137932cards
cared86050092cared
career85822242career
carers85133952carers
cares77369182cares
caret75360562caret
carex144822292carex
cargo85322072cargo
carks115534212carks
carle74535702carle
carls77037422carls
carns75937562carns
carny105822922carny
carob95325222carob
carol75128612carol
carom95025562carom
carper104923632carper
carpi94319392carpi
carps96932252carps
carrel84718632carrel
carrom10513402carrom
carrot8423122carrot
carse74934332carse
carte75940422carte
carter84932272carter
carts78946292carts
carve106227752carve
carver114420142carver
casa65630862casa
case65848082case
cash96636282cash
cask105626432cask
cast67159902cast
cat58282342ca_t
cate66254592cate
cater74840702cater
cats66356342cats
caul65630002caul
cave95941262cave
caver105629062caver
cavy125920002cavy
caw86647932ca_w
caws96036102caws
cay87155982ca_y
cays95437672cays
cere66741472cere
cero66329452cero
chair105519632chair
char95132152char
chard116124742chard
chare105231982chare
chark144222712chark
charm126124662charm
charro114212952charro
charrs115219182charrs
charry145012112charry
chars105936632chars
chart105038282chart
chary135023132chary
chirr105015902chirr
churr104512852churr
cire65836372cire
cirri7710722cirri
claro75018692claro
clary105719612clary
coir66327242coir
cor59960942c_or
cord76740922cord
core67263112core
corer75538872corer
corf95941482corf
cork106635692cork
corm85735372corm
corn69945812corn
cors66656442cors
cory96941512cory
crab85727672crab
crag75625302crag
cram85635492cram
crap85731842crap
craw97725262craw
cru57129562c_ru
cry89726242c_ry
cur56841982c_ur
curb86732222curb
curd77634982curd
cure66149122cure
curer75030752curer
curf97538782curf
curl66035052curl
curn66731882curn
currs75624392currs
curry105920342curry
curs65645542curs
curt67051712curt
czar156013132czar
czars164812912czars
darb76033532darb
dare55848862dare
darer65230792darer
dark95133212dark
darn56434622darn
dart55857872dart
dorr56627722dorr
durr55624352durr
ear36867882ea_r
earl45838142earl
earn46737552earn
ears46356592ears
err35626532_err
fair76332522fair
far67762602fa_r
fard85639062fard
fare76354462fare
farer86733142farer
farl76338552farl
farm95934532farm
faro76136922faro
fart76860562fart
gar47259902ga_r
garb75332672garb
gars55750742gars
gaur56723352gaur
gnarr64810692gnarr
haar77323492haar
hair76330142hair
hard85443502hard
hare76255732hare
hark115237392hark
harl75740002harl
harm95637792harm
harp96134282harp
harry115322952harry
hart76865772hart
jar107646152ja_r
jarl115828132jarl
jars117338352jars
karn86129412karn
kart86750802kart
lair45934152lair
lar37967532la_r
lard56742002lard
lari45839152lari
lark85733862lark
lars46956572lars
maar66025052maar
mair66133762mair
mar57965942ma_r
mara67444562mara
marc87034622marc
mare64759322mare
mark105138052mark
marl66341612marl
marry104821692marry
mars66261862mars
mart66865972mart
murr65225132murr
narc67127952narc
nard56634452nard
nark85230062nark
nary76931222nary
oar37057952oa_r
oars46846032oars
pair66031512pair
par57467022pa_r
para65242172para
pard76441322pard
pare66760842pare
parer75839902parer
park105237492park
parrs75928672parrs
parry105323752parry
pars67560792pars
part65967462part
purr64925812purr
rare45348432rare
rarer54731702rarer
sard55344242sard
sari45444042sari
sark84938972sark
scar66434202sca_r
scare75334462scare
scarer84524602scarer
scarf105427142scarf
scarp95724102scarp
scarry116311182scarry
scars75433532scars
scart76139772scart
scary105222592scary
scaur75814902scaur
tahr75217152tahr
tar37570692ta_r
tare45957622tare
tarn46842722tarn
taro46846912taro
tarp66936412tarp
tarre55825632tarre
tarry85422512tarry
tars46763952tars
tart47566182tart
torr45630902torr
vair75624142vair
var66148332va_r
vara75530882vara
vars75742072vars
vary105226062vary
wair75830052wair
war67262422wa_r
ward86542252ward
ware76254722ware
wark115737772wark
warm95935672warm
warn75239322warn
warp95635002warp
wars78659802wars
wart77866082wart
wary106740012wary
waur76819902waur
yar67253832ya_r
yard85633252yard
yare75636942yare
yarer84321572yarer
yarn75230042yarn
yirr76513572yirr
zarf166929122zarf

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 Filter178691298720.0762351197.4
2DLD Change Limit298723150.95331345.2
3Display Results3153150.0635000.0
 (SQL Overall)1786913151.092163636.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.