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

331 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
barns7633514(None) 
bairns86710871bairns
banns75321231banns
bans66555141ba_ns
barbs95928191barbs
bards87139641bards
bares75457131bares
barfs104826001barfs
barks115735811barks
barms96128461barms
barn66444641barn_
barny105821731barny
barons85025381barons
bars66564091bar_s
brans75437431brans
burns74926781burns
carns75937561carns
darns66927891darns
earns55927561earns
karns96624141karns
tarns56433951tarns
warns87231001warns
yarns85621791yarns
abris75722602abris
ains46158882_ains
airns55521032airns
arbs66834732_arbs
arcs67834782_arcs
ares45871022_ares
arfs76029962_arfs
arks85936872_arks
arms66137492_arms
ars37670932_ar_s
arts49650262_arts
awns75324432_awns
baals76122702baals
baas66844672ba_as
babas96325732babas
babes95834112babes
babus95620332babus
backs135729622backs
bacons104917582bacons
bads77048862ba_ds
baffs134718052baffs
bags76645502ba_gs
bahts105617802bahts
bails75933522bails
bairn77515532bairn_
baits76630582baits
bakes117035372bakes
balas76937212balas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042ba_ls
bams87044452ba_ms
ban58366842ba_n_
band76740912ba_nd
bands85233422bands
bane65250432ba_ne
banes74945582banes
bang74837002ba_ng
bangs85627772bangs
bani65334962ba_ni
bank105835752ba_nk
banks115527902banks
baps86040842ba_ps
bar58070552bar__
barb85240062bar_b
barbe95328282barbe
barbes104526232barbes
barca91319432barca
barcas101016602barcas
bard75648862bar_d
barde85330772barde
bardes95026932bardes
bare65460522bar_e
bared85144482bared
barer74535802barer
barest85327692barest
barf95844412bar_f
barge85631022barge
barges94528252barges
baric96125692baric
baring95135852baring
bark106242152bar_k
barky145721612barky
barm86739602bar_m
barmy125218762barmy
barned95623582barned
barney115314452barney
barneys12569562barneys
baron78131242baron
barong96015822barong
barongs105310832barongs
barony115915302barony
barre75929542barre
barrens94414322barrens
barres84427542barres
barye105021492barye
baryes116218502baryes
baryons121010472baryons
bas58681752ba__s
bases75644352bases
basins85722762basins
basis75429862basis
basks115621762basks
bass66146782ba_ss
basts75936932basts
bates75846342bates
baths105922922baths
batons85519422batons
bats66962332ba_ts
batts76727562batts
bauds85821042bauds
bawds116115492bawds
bawls105719322bawls
bays97143912ba_ys
beans75734692beans
beards94116672beards
bears75739042bear_s
bens65945702b_ens
bergs84718042bergs
berks115423122berks
berms95323662berms
bins66548252b_ins
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
blains84516372blains
blares85021632blares
boards94616932boards
boars75229602boar_s
boarts84716872boarts
boons75031912boons
boras75938302boras
bores76448252bores
borks115727702borks
born67338412born_
borne77926792borne
borons85520542borons
borts76735452borts
bourns84114062bourns
brads85528292brads
braes75735052braes
brags85625102brags
brains85125472brains
bran65740382bran_
brand85124492brand
brands95118942brands
brank115222282brank
branks124817382branks
brant74742172brant
brants85723052brants
bras65746452b_ras
brass75428022brass
brats75336012brats
brawns115614082brawns
braws106425192braws
brays106723112brays
brens75823362brens
brins75533972brins
bris65539612b_ris
bros65635662b_ros
bunns74718292bunns
buns66243722b_uns
burans85019302burans
buras74736302buras
burbs95423492burbs
burds84626062burds
burgs84924092burgs
burins84221892burins
burls74228852burls
burn65636432burn_
burnt75230332burnt
burps94220172burps
burrs74925652burrs
burs65847422bur_s
byres104421382byres
byrls105711232byrls
cains75334302cains
cairns85313302cairns
cans65050852ca_ns
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carls77037422carls
carn66245432carn_
carny105822922carny
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
corns76034762corns
curns74924282curns
damns84916922damns
dans56748152da_ns
darbs85323262darbs
dares66146702dares
darks106727872darks
darn56434622darn_
darts67635732darts
dawns95916592dawns
durns64819872durns
earls56127512earls
earn46737552earn_
ears46356592ear_s
erns45428232_erns
fans76247372fa_ns
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
fauns84516752fauns
fawns115914262fawns
ferns85220082ferns
firns86018542firns
gains65729512gains
garbs86321412garbs
garni6315702garni
gars55750742gar_s
girns64516802girns
grans64832542grans
hards96435652hards
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926872harps
harts88441592harts
herns84825582herns
horns86125332horns
jarls126120962jarls
jars117338352jar_s
kains96125642kains
kaons95014852kaons
karn86129412karn_
karts97630112karts
kbars114612602kbar_s
kerns94719562kerns
kirns95315452kirns
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572lar_s
lawns85215422lawns
learns65513742learns
mains75635112mains
mans66354552ma_ns
maras75443292maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marls75535162marls
mars66261872mar_s
marts77442232marts
morns75527442morns
naans55815252naans
nans46139402na_ns
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
oars46846032oar_s
pains75138282pains
pans65855732pa_ns
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792par_s
parts77743372parts
pawns108818132pawns
pirns76020092pirns
porns75527342porns
rains55140232rains
rares55247442rares
sains55639972sains
sans45153362sa_ns
sarans64224432sarans
sards64736182sards
sarins63932622sarins
saris54544952saris
sarks96632462sarks
saros55238062saros
sharns95516982sharns
sorns55028422sorns
tains54936322tains
tans46154822ta_ns
tares57456562tares
tarn46842722tarn_
taros55640822taros
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
terns55226872terns
trans54933042trans
turns55623242turns
urns46323902_urns
vans76236732va_ns
varas86028192varas
varna84516172varna
varnas94212822varnas
vars75742072var_s
varus85921182varus
wains86930872wains
wans76452272wa_ns
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warn75239322warn_
warps107126422warps
wars78659802war_s
warts814840402warts
yards95324612yards
yarn75230042yarn_
yawns114213272yawns
yearns9509542yearns
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.343520965.0
2DLD Change Limit538003311.65632487.9
3Display Results3313310.0933559.1
 (SQL Overall)1786913312.09285416.3
 
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.