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

288 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
barms9612846(None) 
arms66137491_arms
balms95723921balms
bams87044451ba_ms
barbs95928191barbs
bards87139641bards
bares75457131bares
barfs104826001barfs
barks115735811barks
barm86739601barm_
barmy125218761barmy
barns76335141barns
bars66564091bar_s
berms95323661berms
farms106324951farms
harms106829011harms
warms107726851warms
abris75722602abris
aims67738182_aims
alarms85913052alarms
alms65834922_alms
arbs66834732_arbs
arcs67834782_arcs
ares45871022_ares
arfs76029962_arfs
arks85936872_arks
arm58449622_arm_
army96624182_army
ars37670932_ar_s
arts49650262_arts
arums75517832_arums
baals76122702baals
baas66844672ba_as
babas96325732babas
babes95834112babes
babus95620332babus
backs135729622backs
bads77048862ba_ds
baffs134718052baffs
bags76645502ba_gs
bahts105617802bahts
bails75933522bails
bairns86710872bairns
baits76630582baits
bakes117035372bakes
balas76937212balas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balm85534202balm_
balmy125217472balmy
bals66354042ba_ls
bam78560142ba_m_
bands85233422bands
banes74945582banes
bangs85627772bangs
banks115527902banks
banns75321232banns
bans66555132ba_ns
baps86040842ba_ps
bar58070552bar__
barb85240062bar_b
barbe95328282barbe
barbes104526232barbes
barca91319432barca
barcas101016602barcas
bard75648862bar_d
barde85330772barde
bardes95026932bardes
bare65460522bar_e
bared85144482bared
barer74535802barer
barest85327692barest
barf95844402bar_f
barge85631022barge
barges94528252barges
baric96125692baric
bariums1139142bariums
bark106242152bar_k
barky145721612barky
barman103519702barman
barmen105418532barmen
barmie103816392barmie
barn66444642bar_n
barny105821732barny
baron78131242baron
barons85025382barons
barre75929542barre
barres84427542barres
barye105021492barye
baryes116218502baryes
bas58681752ba__s
bases75644352bases
basis75429862basis
basks115621762basks
bass66146782ba_ss
basts75936932basts
bates75846342bates
baths105922922baths
bats66962332ba_ts
batts76727562batts
bauds85821042bauds
bawds116115492bawds
bawls105719322bawls
bays97143912ba_ys
beams95328172beams
beards94116672beards
bears75739042bear_s
bergs84718042bergs
berks115423122berks
berm86732752berm_
berme96022942berme
bermes106023002bermes
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
blams95023852blams
blares85021632blares
boards94616932boards
boars75229602boar_s
boarts84716872boarts
booms95427122booms
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
bras65746452b_ras
brass75428022brass
brats75336012brats
braws106425192braws
brays106723112brays
brims94721622brims
bris65539612b_ris
bros65635662b_ros
bums85934592b_ums
buras74736292buras
burbs95423492burbs
burds84626062burds
burgs84924092burgs
burls74228852burls
burns74926772burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
byres104421382byres
byrls105711232byrls
calms95222352calms
cams87047282ca_ms
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carls77037422carls
carns75937562carns
caroms105619572caroms
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
charms135218832charms
corms95626222corms
crams96229152crams
dams77444372da_ms
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
derms85022892derms
dorms85723832dorms
drams86025832drams
earls56127512earls
earns55927562earns
ears46356592ear_s
fards96629842fards
fares85852872fares
farls85731112farls
farm95934532farm_
faros85532022faros
farts88336842farts
firms105217422firms
forms105327052forms
gams76648882ga_ms
garbs86321412garbs
gars55750742gar_s
gaums86217072gaums
germs85118872germs
gorms85619592gorms
grams85327312grams
haems105517012haems
halms105225212halms
hams96446132ha_ms
hards96435652hards
harems115513822harems
hares86255542hares
harks126333432harks
harls85634502harls
harm95637792harm_
harps105926862harps
harts88441592harts
herms105626432herms
inarms8410092inarms
jams135231072ja_ms
jarls126120962jarls
jars117338352jar_s
karma113415002karma
karmas123013732karmas
karns96624142karns
karts97630112karts
kbars114612602kbar_s
lams66552262la_ms
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572lar_s
larums83610532larums
maims96321782maims
malms95021552malms
maras75443282maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marls75535162marls
mars66261862mar_s
marts77442232marts
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
norms76019302norms
oars46846032oar_s
palms94921752palms
pams85641762pa_ms
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792par_s
parts77743372parts
perms95524512perms
prams96125512prams
rams65950772ra_ms
rares55247442rares
rearms85114652rearms
sards64736182sards
saris54544952saris
sarks96632462sarks
saros55238062saros
smarms105712532smarms
swarms116112162swarms
tams67247932ta_ms
tares57456562tares
tarns56433952tarns
taros55640822taros
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
terms75523472terms
tharms115712242tharms
trams75327672trams
unarms839242unarms
varas86028192varas
vars75742072var_s
varus85921182varus
wards97734402wards
wares88250582wares
warks127932402warks
warm95935672warm_
warns87231002warns
warps107126422warps
wars78659802war_s
warts814840402warts
worms105320752worms
yams95330732ya_ms
yards95324612yards
yarns85621792yarns
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.1731032896.0
2DLD Change Limit538002881.89028465.6
3Display Results2882880.0763789.5
 (SQL Overall)1786912882.13983539.5
 
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.