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 “brahma” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

247 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
brahma133619(None) 
brahmas1436731brahmas
brachia141910422brachia
brava106414792bra_va
braza165214252bra_za
bregma1134962bregma
drachma1544302drachma
drama85117412dra_ma
graham1237852graham
grama85620282gra_ma
gramma11499802gramma
trauma838802trauma
abrachia1545843abrachia
agama85815573aga_ma
agma77623263__agma
aha611246643__ah_a
alma66333023__alma
ama510853303__a_ma
arame75026623ara_me
aroma71220143ar_oma
asrama839193asra_ma
asthma11126563asthma
atma68121773__atma
baa510650423b_a__a
baba88828353b_a_ba
babka137812913b_abka
bacca111012183b_acca
badman113813843b_adman
bagman114613813b_agman
bah87755353b_ah__
baht96740013b_ah_t
bahts105617803b_ahts
baiza164813223b_aiza
balm85534203b_alm_
balms95723923b_alms
balmy125217473b_almy
balsa77920413b_alsa
bam78560143b_a_m_
bams87044453b_a_ms
banda85223103b_anda
barathea1345273barathea
barca91319433b_arca
barhop13319643barhop
barm86739603b_arm_
barman103519703b_arman
barms96128463b_arms
barmy125218763b_army
baryta114310293baryta
bathmat14510143bathmat
batman105214063b_atman
bayman133712703b_ayman
beadman12249153beadman
beam86939233bea_m_
beams95328173bea_ms
beamy126218573bea_my
bema85825253b__ema
bertha11429173berth_a
bhakta1533653bhakta
bima86723833b__ima
blah98625063blah__
blahs105616513blah_s
blam86131703bla_m_
blame95625493bla_me
blams95023853bla_ms
boatman1147053boatman
bohea105013733b_ohea
bra56339463br___a
brace95629273bra_ce
braced115420603braced
bracer104620583bracer
braces108427773braces
brach126123303bra_ch
braches144621223braches
brachet144020313brachet
brachial15219303brachial
brachs134415753brachs
bract96332723bra_ct
bracts105617773bracts
brad75234343bra__d
brads85528293bra_ds
brae65639113bra__e
braes75735053bra_es
brag75229723bra__g
braggy13337173braggy
brags85625103bra_gs
braid85822263bra_id
braids95015683braids
brail75525553bra_il
brails84621293brails
brain76229383bra_in
brains85125473brains
brainy114815643brainy
braise84318753braise
braize174113113braize
brake116025343bra_ke
braked135318693braked
brakeman1644313brakeman
brakes124923123brakes
braky145015813bra_ky
bran65740383bra__n
branch134014773branch
branchia15217713branchia
brand85124493bra_nd
brands95118943brands
brandy124712063brandy
brank115222283bra_nk
branks124817383branks
branny115111833branny
brans75437433bra_ns
brant74742173bra_nt
brants85723053brants
bras65746453bra__s
brash106221563bra_sh
brasher124515233brasher
brashes124518463brashes
brashly15427613brashly
brashy145210593brashy
brasil8713863brasil
brass75428023bra_ss
brassy11509233brassy
brat66055543bra__t
brats75336013bra_ts
bratty1159683bratty
bravas114913323bravas
brave104925503bra_ve
braved124817443braved
braver114719043braver
braves115524083braves
bravi104715753bra_vi
bravo105214343bra_vo
bravos114711393bravos
bravura1253603bravura
braw94829563bra__w
brawer114216333brawer
brawl106217963bra_wl
brawls115214333brawls
brawly144312353brawly
brawn106018563bra_wn
brawns115614083brawns
brawny144710603brawny
braws106425193bra_ws
braxy175410893bra_xy
bray95232903bra__y
brayed124615783brayed
brayer115315313brayer
brays106723113bra_ys
brazas175812433brazas
braze165423453bra_ze
brazed184717083brazed
brazen174812453brazen
brazer174917533brazer
brazes175522193brazes
brazil1779623brazil
bream95121813bream_
breams104815043breams
brecham1646833brecham
brim85629373br_im_
brims94721623br_ims
bromal10313653br_omal
brome94421973br_ome
bromo95217203br_omo
broom95022213broom_
brooms104915873brooms
broomy13449953broomy
brumal1049503br_umal
brume95817983br_ume
bushman1455693bushman
bushwa14105143bushwa
bwana10310243bwa_na
chacma1537903chacma
cram85635493cra_m_
cramp115120693cra_mp
crams96229153cra_ms
crania82418433crania
dharma1276103dharma
drachm1436493drachm_
drachmae1643933drachmae
drachmai1653243drachmai
drachmas1644863drachmas
drachms1534253drachms
dram75832003dra_m_
dramas95814653dra_mas
drams86025833dra_ms
drayman1335433drayman
fraena938063fraena
frame105821803fra_me
gama77035513_ga_ma
gamma106116103_gamma
grahams1335333grahams
gram77034583gra_m_
gramas94317203gra_mas
grammar12406893grammar
grammas12499773grammas
gramme114210333gramme
gramp106218323gra_mp
grampa115010173grampa
grams85327313gra_ms
grana65722093gra_na
grandma1136913grandma
grappa11396443grappa
haha107821063_hah_a
halma108219253_halma
karma113415003_karma
lama66635293_la_ma
llama799893lla_ma
magma104513573_magma
mama86231583_ma_ma
mamma86317913_mamma
miasma1097563miasma
plasma103810913plasma
praam94815613praam_
praams10459643praams
prahu105013973prah_u
prahus11458243prahus
prajna1535073prajna
pram85733493pra_m_
prams96125513pra_ms
prima95019343pr_ima
raga55930813_ra_ga
ragman94013713_ragman
rah68052403_rah__
raia46638383_ra_ia
raita54623073_raita
raja117918683_ra_ja
ram56867273_ra_m_
ramal74622243_ra_mal
rami66034093_ra_mi
rammy124312493_rammy
ramp85934003_ra_mp
rams65950773_ra_ms
raphia113511263_raphia
raya75224823_ra_ya
regma84612333_regma
rhea75017433_r_hea
sradha1085333sradha
tarama8412723tarama
trachea12311673trachea
trachoma15116623trachoma
tram67034553tra_m_
tramp96319773tra_mp
trams75327673tra_ms
trashman1345813trashman
traumas938583traumas
tryma1037223tr_yma
ulama7711473ula_ma
uraemia946503uraemia
urania62516123urania

Search took 7 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127162476.03018692.5
3Display Results2472470.0763250.0
 (SQL Overall)1786912476.24928595.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.