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

220 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
brr5692192(None) 
bar58070551bar
birr66022351birr
bra56339461bra
bro56236601bro
brrr65312291brrr
bur55744691bur
burr65631231burr
err35626531err
abri65522212abri
air38058392air
ar211379382_ar
arb510448422arb
arc510250902arc
are37874572are
arf67453372arf
ark77044962ark
arm58449622arm
ars37670932ars
art38679142art
ba49962342b_a
baa510650422baa
bad67763152bad
bag67059222bag
bah87755352bah
bal56662722bal
bam78560142bam
ban58366832ban
bap76455842bap
barb85240062barb
bard75648862bard
bare65460522bare
barer74535802barer
barf95844402barf
bark106242152bark
barm86739602barm
barn66444642barn
barre75929542barre
bars66564092bars
bas58681752bas
bat510988952bat
bay89661642bay
be47948942b_e
bear66844642bear
bed67950622bed
bee56262402bee
beer65635992beer
beg65944132beg
bel57148462bel
ben56554922ben
berg75425542berg
berk105929842berk
berm86732752berm
berry104521762berry
bes56557432bes
bet58376672bet
bey86645422bey
bi48046462b_i
bib77045922bib
bid67751782bid
bier65531822bier
big67345712big
bin56658632bin
bio57846072bio
bird76128312bird
birk106326852birk
birl65830462birl
biro66131202biro
birrs74917102birrs
bis56860652bis
bit57070892bit
biz147939352biz
blur66020532blur
bo410957572b_o
boa56954032boa
boar66134292boar
bob76755662bob
bod67055542bod
bog67852412bog
boo58163662boo
boor66130682boor
bop77549482bop
bora66141632bora
bore66051332bore
borer75131272borer
bork106933822bork
born67338412born
bort65960962bort
bos57966812bos
bot59680402bot
bow87051902bow
box1210142342box
boy87753562boy
brad75234342brad
brae65639112brae
brag75229722brag
bran65740382bran
bras65746452bras
brat66055542brat
braw94829562braw
bray95232902bray
bred75130972bred
bree67241262bree
bren65629562bren
brew95023562brew
briar75718152briar
brie65837902brie
brier74527402brier
brig76528032brig
brim85629372brim
brin67038192brin
brio65432492brio
bris65539612bris
brit66350152brit
broo65129822broo
bros65635662bros
brow97228442brow
brut66537962brut
brux136315272brux
bub76343972bub
bud67041272bud
bug65340742bug
buhr95315382buhr
bum75342692bum
bun56348142bun
bura66139532bura
burb85334672burb
burd75534262burd
burg74930362burg
burl64937182burl
burn65636422burn
burp85028882burp
burro75018492burro
burrs74925652burrs
burry105221562burry
burs65847422burs
bury95633592bury
bus56950972bus
but55963022but
buy86436542buy
by77529232b_y
bye86134592bye
byre95023852byre
byrl95716012byrl
bys85229462bys
car59165562car
carr65434702carr
cor59960942cor
cru57129562cru
cry89726242cry
cur56841982cur
curr65429652curr
dor47253922dor
dorr56627722dorr
dry76526032dry
durr55624352durr
ear36867882ear
er28345142_er
era35741502era
ere36352772ere
erg45531072erg
ern35738352ern
errs45622532errs
ers36046282ers
far67762602far
fer66646122fer
fir66744892fir
for66952072for
fro65530642fro
fry96226502fry
fur66637322fur
gar47259902gar
gor47848262gor
her66547812her
ire36943172ire
irk76426362irk
jar107646152jar
kbar106514652kbar
kir76535672kir
kor76538892kor
lar37967532lar
mar57965942mar
mir57046762mir
mor56855002mor
murr65225132murr
nor38048822nor
oar37057952oar
or27354732_or
ora37250832ora
orb55736862orb
orc57034922orc
ore36661832ore
orra46120722orra
ors35750112ors
ort39465232ort
our36042892our
par57467022par
parr65731152parr
per56353092per
pro55837262pro
pry85728052pry
pur56840552pur
purr64925812purr
re26153742_re
ser36752402ser
sir35746672sir
sri35634002sri
tar37570692tar
tor39261682tor
torr45630902torr
try66529672try
urb55731102urb
urd46427042urd
urn35731462urn
urp56426392urp
var66148332var
war67262422war
wry96524702wry
yar67253832yar
yirr76513572yirr

Search took 1 second 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 Filter178691140840.0602978183.3
2DLD Change Limit140842200.44032009.1
3Display Results2202200.0307333.3
 (SQL Overall)1786912200.530337152.8
 
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.