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

340 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
brae6563911(None) 
bare65460521bare
blae66134641blae
bra56339461bra_
brace95629271brace
brad75234341brad
braes75735051braes
brag75229721brag
brake116025341brake
bran65740381bran
bras65746451bras
brat66055541brat
brave104925501brave
braw94829561braw
bray95232901bray
braze165423451braze
bree67241261bree
brie65837901brie
frae75330471frae
abrade9313052abrade
ae212590292__ae
alae45643752alae
arak86929572arak
arame75026622arame
are37874572ar_e
area45843392area
areae55229742areae
arse46539272arse
aurae54128112aurae
ba49962342b_a_
baa510650422b_aa
baaed85218162baaed
baal67033112baal
baas66844672baas
babe86835812babe
bad67763152b_ad
bade75140882bade
bag67059222b_ag
bah87755352b_ah
bake105637512bake
bal56662722b_al
bale66353842bale
bam78560142b_am
ban58366832b_an
bane65250422bane
bap76455842b_ap
bar58070552b_ar
barb85240062barb
barbe95328282barbe
bard75648862bard
barde85330772barde
bared85144482bared
barer74535802barer
bares75457132bares
barf95844402barf
barge85631022barge
bark106242152bark
barm86739602barm
barn66444642barn
barre75929542barre
bars66564092bars
barye105021492barye
bas58681752b_as
base64847022base
bat510988952b_at
bate66552422bate
bay89661642b_ay
be47948942b__e
bead75937922bead
beak106534382beak
beam86939232beam
bean66443862bean
bear66844642bear
beat66168302beat
beau66137272beau
bee56262402b_ee
bene66439492bene
berake124216082berake
berate84729022berate
berme96022942berme
bias64738152bias
bice86235552bice
bide76041472bide
bike106532592bike
bile66147172bile
bine66650852bine
birle75023632birle
birse74517402birse
bise66437092bise
bite66546992bite
bize155926282bize
blab86629132blab
blade85923332blade
blah98625062blah
blam86131702blam
blame95625492blame
blare75826232blare
blase75524232blase
blat66550952blat
blate75933782blate
blaw97026722blaw
blaze165520832blaze
blue65328462blue
boa56954032boa_
boar66134292boar
boas66150832boas
boat66360312boat
bode75838752bode
bole66448692bole
bone65949322bone
bora66141632bora_
borage93917012borage
boral75831702boral
borane84620212borane
boras75938302boras
borate85026152borate
borax145918722borax
bore66051332bore
borne77926792borne
braced115420602braced
bracer104620582bracer
braces108427772braces
brach126123302brach
bract96332722bract
brads85528292brads
brags85625102brags
braid85822262braid
brail75525552brail
brain76229382brain
braise84318752braise
braize174113112braize
braked135318692braked
brakes124923122brakes
braky145015812braky
brand85124492brand
brank115222282brank
brans75437432brans
brant74742172brant
brash106221562brash
brass75428022brass
brats75336012brats
brava106414792brava
braved124817442braved
braver114719042braver
braves115524082braves
bravi104715752bravi
bravo105214342bravo
brawer114216332brawer
brawl106217962brawl
brawn106018562brawn
braws106425192braws
braxy175410892braxy
brayed124615782brayed
brayer115315312brayer
brays106723112brays
braza165214252braza
brazed184717082brazed
brazen174812452brazen
brazer174917532brazer
brazes175522192brazes
bread85523112bread
break115319402break
bream95121812bream
bred75130972bred
brede85520502brede
breed85526692breed
brees75632552brees
bren65629562bren
breve105317052breve
brew95023562brew
briar75718152briar
bribe94820772bribe
bride86425532bride
brief105422592brief
brier74527402brier
bries74942152bries
brig76528032brig
brim85629372brim
brin67038192brin
brine75132272brine
brio65432492brio
bris65539612bris
brit66350152brit
bro56236602br_o
broad84817692broad
broke116019782broke
brome94421972brome
broo65129822broo
bros65635662bros
brose75227032brose
brow97228442brow
brr56921922br_r
brrr65312292brrr
brume95817982brume
brut66537962brut
brute75321782brute
brux136315272brux
bura66139532bura_
buran75225302buran
buras74736292buras
burke115122762burke
bursae84515602bursae
burse75527252burse
bute66739672bute
bye86134592b_ye
byre95023852byre
byte96521812byte
care66968372care
crab85727672crab
crag75625302crag
crake114823522crake
cram85635492cram
crane75331602crane
crap85731842crap
crape96128442crape
crate76537402crate
crave105626312crave
craw97725262craw
craze165221462craze
dare55848862dare
drab76226452drab
drag64825052drag
drake104918302drake
dram75832002dram
drape85319632drape
drat56247832drat
drave95219272drave
draw85623012draw
dray85428092dray
dree56638322dree
era35741502era_
eras45441502eras
erase54925492erase
ere36352772er_e
erne46727422erne
fare76354462fare
frag85126272frag
frame105821802frame
frap95925812frap
frat75648542frat
fray105428902fray
free75940182free
froe75329992froe
gae46457702_gae
grab75427612grab
grace85124542grace
grad66829862grad
grade75126092grade
gram77034582gram
gran56335012gran
grape84824662grape
grat55651282grat
grate64932882grate
grave94624872grave
gray85329892gray
graze155820052graze
gree56641562gree
grue55825712grue
hae67364002_hae
hare76255732hare
irade65618152irade
irate55627982irate
ire36943172ir_e
kae76744542_kae
librae84310172librae
mae57659102_mae
mare64759322mare
morae75831192morae
nae35952742_nae
ora37250832ora_
orad56031692orad
oral47638122oral
orate55133302orate
ore36661832or_e
orle45630462orle
parae76335702parae
pare66760842pare
pram85733492pram
prao66229022prao
prase76128752prase
prat65952042prat
prate75135982prate
prau66529472prau
pray96331532pray
pree67044732pree
race66746262_race
rad47662002_rad
rag45761322_rag
rage55742352_rage
rah68052402_rah
rai37658222_rai
raj105740222_raj
rake84841572_rake
rale45050562_rale
ram56867272_ram
ran38266612_ran
rap56261962_rap
rape65041632_rape
rare45348432_rare
ras37575392_ras
rase46149982_rase
rat37892742_rat
rate45458762_rate
rave75542092_rave
raw67252252_raw
rax108445722_rax
ray66361992_ray
raze135235432_raze
re26153742_r_e
ree37974072_ree
roe36861072_roe
rue35549262_rue
rye66032542_rye
sae38365182_sae
spae65034322spae
tae38267052_tae
tare45957622tare
thae76825562thae
trace75829612trace
trad55630912trad
trade65026042trade
tram67034552tram
trap67532802trap
trave85223032trave
tray77632592tray
tree47745812tree
true46725852true
twae74719572twae
umbrae1038672umbrae
uraei53016082uraei
urare56322552urare
urase54624682urase
urate55432162urate
urea46528052urea
urge54722412urge
ursae55214452ursae
wae67556952_wae
ware76254722ware
wrap96821972wrap
yare75636942yare

Search took 2 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 Filter178691298720.0632836365.1
2DLD Change Limit298723401.33022460.2
3Display Results3403400.1402428.6
 (SQL Overall)1786913401.533116562.9
 
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.