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

306 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
carrs7573085(None) 
carbs96031461carbs
cards85137931cards
carers85133961carers
cares77369181cares
carks115534211carks
carls77037421carls
carns75937561carns
carps96932251carps
carr65434701carr_
carry105823781carry
cars67364761ca_rs
carts78946291carts
charrs115219191charrs
currs75624391currs
parrs75928671parrs
acarus8312192acarus
acres76327762acres
airs46447422_airs
arbs66834732_arbs
arcs67834782_arcs
ares45871022_ares
arfs76029962_arfs
arks85936872_arks
arms66137492_arms
arras55626132_arras
arris56824682_arris
ars37670932_a_rs
arts49650262_arts
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
barre75929542barre
barres84427542barres
bars66564092ba_rs
birrs74917102birrs
burrs74925652burrs
cabers105023922cabers
cabs86739422ca_bs
cacas95627982cacas
cades85440732cades
cadis84428502cadis
cadre85419022cadre
cadres94017932cadres
cads76144522ca_ds
cafes106426922cafes
caffs135417372caffs
cagers95624192cagers
cages85936012cages
caids85226422caids
cains75334302cains
caird85717232caird
cairds96411512cairds
cairn75717512cairn
cairns85313302cairns
cakes116037672cakes
calfs104919382calfs
calks115421602calks
calls75634732calls
calms95222352calms
calos74431902calos
camas96333522camas
cames97047312cames
camos95927612camos
camps116330262camps
cams87047282ca_ms
caners84629202caners
canes75350372canes
cans65050852ca_ns
cants77036942cants
capers105428142capers
capes95441922capes
caphs124515372caphs
capos94826072capos
capris10415082capris
caps87147892ca_ps
car59165562ca_r_
carat75048792carat
carats85929022carats
carb85143162ca_rb
carbo94923842carbo
carbos105122262carbos
card710245872ca_rd
carders104820352carders
care66968372ca_re
cared86050092cared
careers95218782careers
carer74942332carer
caress85720262caress
caret75360562caret
carets85330772carets
carex144822302carex
cargo85322072cargo
cargos94619182cargos
caries85147622caries
cark105539272ca_rk
carl65144782ca_rl
carle74535702carle
carles85435082carles
carn66245432ca_rn
carny105822922carny
carob95325222carob
carobs104818102carobs
carol75128612carol
carols85124982carols
carom95025562carom
caroms105619572caroms
carp85139812ca_rp
carpers114521252carpers
carpi94319392carpi
carpus105514302carpus
carrel84718632carrel
carrels95117302carrels
carries94328012carries
carrom10513402carrom
carroms11512402carroms
carrot8423122carrot
carrots9714622carrots
carse74934332carse
carses85233652carses
cart66570342ca_rt
carte75940422carte
carters95327252carters
cartes86239472cartes
carve106227752carve
carvers124817542carvers
carves115128452carves
casas75327842casas
cases75048382cases
casks115720062casks
casts77237792casts
casus76419252casus
caters85336502caters
cates75951892cates
cats66356342ca_ts
cauls75727772cauls
cavers115026842cavers
caves105639702caves
caws96036112ca_ws
cays95437672ca_ys
ceres75540012ceres
ceros74726072ceros
chairs114916182chairs
charas114223612charas
chards125119732chards
chares115631802chares
charks155219702charks
charms135218842charms
charr104821782charr_
charro114212952charro
charros124312142charros
charry145012112charry
chars105936642chars
charts115823092charts
chirrs114514982chirrs
churrs115111512churrs
cires74932912cires
cirri7710722cirri
cirrus8349172cirrus
claros84015112claros
coirs75221052coirs
cords86030622cords
corers85231072corers
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442c_ors
crabs95421392crabs
crags85622572crags
crams96229152crams
craps95328642craps
crass76328042crass
craws105723122craws
cris66233432c_ris
crus65828482c_rus
curbs94821652curbs
curds85725612curds
curers84923192curers
cures75645432cures
curfs105122142curfs
curls74927102curls
curns74924282curns
curr65429652curr_
curry105920342curry
curs65645542c_urs
czars164812912czars
darbs85323262darbs
darers75921872darers
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
dorrs65520592dorrs
durrs65519992durrs
earls56127512earls
earns55927562earns
ears46356592ea_rs
errs45622532_errs
fairs85825442fairs
fards96629842fards
farers95924052farers
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
garbs86321412garbs
gars55750742ga_rs
gaurs66317992gaurs
gnarrs7407662gnarrs
haars85620472haars
hairs86225172hairs
hards96435652hards
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926872harps
harry115322952harry
harts88441592harts
jarls126120962jarls
jars117338352ja_rs
karns96624142karns
karts97630112karts
lairs55425872lairs
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572la_rs
maars74621632maars
mairs76228302mairs
maras75443292maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marls75535162marls
marry104821692marry
mars66261872ma_rs
marts77442232marts
murrs75521302murrs
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
oars46846032oa_rs
pairs75325832pairs
paras76143042paras
pards85634332pards
parers85530742parers
pares77164482pares
paris75145942paris
parks116134462parks
parr65731152parr_
parry105323752parry
pars67560792pa_rs
parts77743372parts
purrs75320432purrs
rares55247442rares
sards64736182sards
saris54544952saris
sarks96632462sarks
saros55238062saros
scarers94618512scarers
scares85033002scares
scarfs114714682scarfs
scarps104718602scarps
scarry116311182scarry
scars75433532sca_rs
scarts85321492scarts
scaurs85512052scaurs
tahrs85412332tahrs
tares57456562tares
tarns56433952tarns
taros55640822taros
tarps76527112tarps
tarre55825632tarre
tarres64723042tarres
tarry85422512tarry
tars46763952ta_rs
tarts57242022tarts
torrs53923562torrs
vairs85019132vairs
varas86028192varas
vars75742072va_rs
varus85921182varus
wairs86424062wairs
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802wa_rs
warts814840402warts
yards95324612yards
yarns85621792yarns
yirrs8469192yirrs
zarfs174713622zarfs

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.500357382.0
2DLD Change Limit538003061.81329674.6
3Display Results3063060.0764026.3
 (SQL Overall)1786913062.38974797.4
 
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.