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

254 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
barfs10482600(None) 
arfs76029961_arfs
baffs134718051baffs
barbs95928191barbs
bards87139641bards
bares75457131bares
barf95844411barf_
barks115735811barks
barms96128461barms
barns76335141barns
bars66564091bar_s
zarfs174713621zarfs
abris75722602abris
arbs66834732_arbs
arcs67834782_arcs
ares45871022_ares
arf67453372_arf_
arks85936872_arks
arms66137492_arms
ars37670932_ar_s
arts49650262_arts
baals76122702baals
baas66844672ba_as
babas96325732babas
babes95834112babes
babus95620332babus
backs135729622backs
bads77048862ba_ds
baff124632272ba_ff
baffy165511922baffy
bags76645502ba_gs
bahts105617802bahts
bails75933522bails
bairns86710872bairns
baits76630582baits
bakes117035372bakes
balas76937212balas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042ba_ls
bams87044452ba_ms
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
barfed125416382barfed
barfly14339652barfly
barge85631022barge
barges94528252barges
baric96125692baric
bark106242152bar_k
barky145721612barky
barm86739602bar_m
barmy125218762barmy
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
beards94116672beards
bears75739042bear_s
beefs105618562beefs
bergs84718042bergs
berks115423122berks
berms95323662berms
biffs134814412biffs
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
blaffs14426622blaffs
blares85021632blares
boards94616932boards
boars75229602boar_s
boarts84716872boarts
boffs134915502boffs
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
bras65746452b_ras
brass75428022brass
brats75336012brats
braws106425192braws
brays106723112brays
bris65539612b_ris
bros65635662b_ros
buffs135519512buffs
bumfs125414052bumfs
buras74736292buras
burbs95423492burbs
burds84626062burds
burgs84924092burgs
burls74228852burls
burns74926772burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
byres104421382byres
byrls105711232byrls
caffs135417372caffs
calfs104919382calfs
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carls77037422carls
carns75937562carns
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
curfs105122142curfs
daffs125116422daffs
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
dwarfs13436272dwarfs
earls56127512earls
earns55927562earns
ears46356592ear_s
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
gaffs124914652gaffs
garbs86321412garbs
gars55750742gar_s
haafs115711162haafs
hards96435652hards
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926862harps
harts88441592harts
jarls126120962jarls
jars117338352jar_s
kafs116423742ka_fs
kaifs125715642kaifs
karns96624142karns
karts97630112karts
kbars114612602kbar_s
kerfs125413572kerfs
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572lar_s
maras75443282maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marls75535162marls
mars66261862mar_s
marts77442232marts
naffs116213962naffs
naifs87617422naifs
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
oafs76425262oa_fs
oars46846032oar_s
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792par_s
parts77743372parts
raffs115017522raffs
rares55247442rares
sards64736182sards
saris54544952saris
sarks96632462sarks
saros55238062saros
scarfs114714682scarfs
serfs84922012serfs
snarfs95113422snarfs
surfs85022542surfs
swarfs125612062swarfs
tares57456562tares
tarns56433952tarns
taros55640822taros
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
turfs84620442turfs
varas86028192varas
vars75742072var_s
varus85921182varus
waffs146315472waffs
waifs115719872waifs
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802war_s
warts814840402warts
wharfs1546372wharfs
yaffs145311122yaffs
yards95324612yards
yarns85621792yarns
zarf166929122zarf_

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.0802233637.5
2DLD Change Limit538002541.89028465.6
3Display Results2542540.0604233.3
 (SQL Overall)1786912542.03088025.1
 
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.