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

327 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
brans7543743(None) 
bans66555131b_ans
barns76335141barns
beans75734691beans
brads85528291brads
braes75735051braes
brags85625101brags
brains85125471brains
bran65740381bran_
brand85124491brand
brands95118941brands
brank115222281brank
branks124817381branks
brant74742171brant
brants85723051brants
bras65746451bra_s
brass75428021brass
brats75336011brats
brawns115614081brawns
braws106425191braws
brays106723111brays
brens75823361brens
brins75533971brins
burans85019301burans
grans64832541grans
trans54933041trans
alans55636172alans
araks94820882araks
azans146516882azans
baals76122702baals
baas66844672b_aas
bads77048862b_ads
bags76645502b_ags
bals66354042b_als
bams87044452b_ams
ban58366832b_an_
band76740902b_and
bands85233422b_ands
bane65250422b_ane
banes74945582b_anes
bang74836992b_ang
bangs85627772b_angs
bani65334952b_ani
bank105835742b_ank
banks115527902b_anks
banns75321232banns
baps86040842b_aps
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barn66444642barn_
barny105821732barny
barons85025382barons
bars66564092b_ars
bas58681752b_a_s
bass66146782b_ass
bats66962332b_ats
bays97143912b_ays
beads85429502beads
beaks115326622beaks
beams95328172beams
bean66443862bean_
beano75421552beano
beanos85516512beanos
bears75739042bears
beats76042242beats
beaus75127112beaus
bens65945702b_ens
bhang115512922bhang
bhangs12449662bhangs
bias64738152bia_s
bins66548242b_ins
blabs95619632blabs
blahs105616512blahs
blains84516372blains
blams95023852blams
bland85320452bland
blank115418552blank
blanks124112892blanks
blats75132502blats
blaws105620462blaws
boars75229602boars
boas66150832boa_s
boats75635152boats
bogans95714812bogans
boons75031912boons
borals86721912borals
borane84620212borane
boranes93720402boranes
boras75938302bora_s
borons85520542borons
bra56339462bra__
brace95629272brace
braces108427772braces
brach126123302brach
brachs134415752brachs
bract96332722bract
bracts105617772bracts
brad75234342bra_d
brae65639112bra_e
brag75229722bra_g
braid85822262braid
braids95015682braids
brail75525552brail
brails84621292brails
brain76229382brain
brainy114815642brainy
braise84318752braise
brake116025342brake
brakes124923122brakes
braky145015812braky
branch134014772branch
brandy124712062brandy
branny115111832branny
brash106221562brash
brassy11509232brassy
brat66055542bra_t
brava106414792brava
bravas114913322bravas
brave104925502brave
braves115524082braves
bravi104715752bravi
bravo105214342bravo
bravos114711392bravos
braw94829562bra_w
brawl106217962brawl
brawls115214332brawls
brawn106018562brawn
brawny144710602brawny
braxy175410892braxy
bray95232902bra_y
braza165214252braza
brazas175812432brazas
braze165423452braze
brazens18418712brazens
brazes175522192brazes
breads95419202breads
breaks124816422breaks
breams104815042breams
brees75632552brees
bren65629562bren_
brent75734132brent
brents84717272brents
brews105617072brews
briars84814822briars
bries74942152bries
brigs85823222brigs
brims94721622brims
brin67038192brin_
brine75132272brine
brines85028852brines
bring85528502bring
brings94618432brings
brink116122002brink
brinks124616312brinks
briny104719662briny
brios74725722brios
bris65539612br_is
briss75824272briss
brits76433082brits
broads94515142broads
brogans1049662brogans
bronc91714342bronc
broncs101611152broncs
broos75126412broos
bros65635662br_os
browns116415632browns
brows105425982brows
bruins86014952bruins
brung84613912brung
brunt75728752brunt
brunts85215452brunts
bruts75922952bruts
bunas75126572bunas
bunns74718292bunns
buns66243722b_uns
buran75225302buran_
buras74736292bura_s
burins84221892burins
burns74926772burns
bwana10310242bwana
bwanas1157442bwanas
cans65050842_cans
carns75937562carns
clans75031012clans
crabs95421392crabs
crags85622572crags
crams96229152crams
crane75331602crane
cranes84330752cranes
crank114819612crank
cranks125015312cranks
craps95328642craps
crass76328042crass
craws105723122craws
cyans105714812cyans
dans56748142_dans
darns66927892darns
deans66131392deans
drabs85119672drabs
drags75521112drags
drains73719402drains
drams86025832drams
drank104816202drank
drats66628372drats
draws95119372draws
drays95819772drays
earns55927562earns
elans55527752elans
eras45441502era_s
erns45428222er_ns
fans76247362_fans
flans85327972flans
frags96322162frags
franc104615412franc
francs114112192francs
frank124417512frank
franks134912732franks
fraps105620552fraps
frass85321122frass
frats86829672frats
frays116920102frays
frons86124042frons
furans94515952furans
glans65125832glans
grabs85719692grabs
grads75625752grads
grains74223092grains
grams85327312grams
gran56335012gran_
grana65722092grana
grand75122692grand
grands84218242grands
grant64840022grant
grants73722472grants
grass66125202grass
grays95621332grays
grins65427222grins
groans74815062groans
guans64419442guans
irons55324132irons
jeans126022112jeans
karns96624142karns
khans124615172khans
koans95818622koans
leans55536252leans
loans56026462loans
lorans65117602lorans
mans66354532_mans
means75831222means
moans74624362moans
naans55815252naans
nans46139392_nans
orals55826482orals
orang65119942orang
orangs74116032orangs
organs7912912organs
pans65855722_pans
peans75437642peans
pians75126962pians
plans75731272plans
prams96125512prams
prang84820322prang
prangs94816232prangs
prank115019452prank
pranks124814722pranks
praos74923562praos
prats76333392prats
praus74621752praus
prawns11509022prawns
prays105022432prays
pyrans11411062pyrans
rads56046602_rads
rags55448372_rags
rains55140232_rains
rais45252622_rais
rams65950772_rams
ran38266612_ran_
rand55839562_rand
rands65930452_rands
rang56939152_rang
rani46640102_rani
ranis55235832_ranis
rank85135522_rank
ranks95225732_ranks
rant45864672_rant
rants55935342_rants
raps66247732_raps
ras37575392_ra_s
rats46260372_rats
raws75238212_raws
rays77642352_rays
rins46153192_rins
roans54926442roans
runs46438072_runs
sans45153352_sans
sarans64224432sarans
scans74625102scans
spans74528732spans
swans84625012swans
tans46154812_tans
tarns56433952tarns
trains64725342trains
trams75327672trams
trank96222422trank
tranks104017762tranks
tranq145416892tranq
tranqs155210312tranqs
traps75727482traps
trass56226472trass
trays85623432trays
ulans54921302ulans
urns46323892ur_ns
vans76236722_vans
wans76452262_wans
warns87231002warns
weans85326742weans
wrang94716112wrang
wrangs104611912wrangs
wraps105617152wraps
wrens85016242wrens
yarns85621792yarns
yeans86624882yeans
yuans84613322yuans

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.0961861364.6
2DLD Change Limit538003271.85628987.1
3Display Results3273270.0963406.3
 (SQL Overall)1786913272.04887251.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.