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

181 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
brahmas143673(None) 
brahma1336191brahma_
bravas114913322bra_vas
brazas175812432bra_zas
drachmas1644862drachmas
dramas95814662dra_mas
grahams1335332grahams
gramas94317202gra_mas
grammas12499772grammas
traumas938592traumas
abrachias1645633abrachias
agamas97413453aga_mas
agmas85919873__agmas
almas76629773__almas
amas67746293__a_mas
arames84622573ara_mes
aromas81018613ar_omas
asramas938303asra_mas
asthmas12117363asthmas
atmas75721013__atmas
baas66844673b_a__as
babas96325733b_a_bas
babkas146010143b_abkas
badman113813843b_adman
bagman114613813b_agman
bahts105617803b_ah_ts
baizas173810823b_aizas
balas76937213b_a_las
balms95723923b_alm_s
balsas86417523b_alsas
bams87044453b_a_m_s
bandas95120543b_andas
baratheas1444933baratheas
barcas101016603b_arcas
barhops14288113barhops
barman103519703b_arman
barms96128463b_arm_s
barytas12378283barytas
bathmat14510143bathmat
bathmats1545933bathmats
batman105214063b_atman
bayman133712703b_ayman
beadman12249153beadman
beams95328173bea_m_s
bemas96424283b__emas
berthas12398763berth_as
bhaktas1633643bhaktas
bimas95521743b__imas
blahs105616513blah__s
blames105121863bla_mes
blams95023853bla_m_s
boatman1147053boatman
boheas114013213b_oheas
bracers114616703bracers
braces108427773bra_ces
braches144621223braches
brachets154311983brachets
brachia141910423brachia_
brachial15219303brachial
brachials16206943brachials
brachs134415753bra_chs
bracts105617773bra_cts
brads85528293bra__ds
braes75735053bra__es
brags85625103bra__gs
braids95015693bra_ids
brails84621293bra_ils
brains85125473bra_ins
braises93818873braises
braizes183112453braizes
brakeman1644313brakeman
brakes124923123bra_kes
braless92910563braless
brands95118943bra_nds
branks124817383bra_nks
brans75437433bra__ns
brants85723053bra_nts
bras65746453br___as
brashes124518463brashes
brasils9410973brasils
brass75428023bra__ss
brasses93818353brasses
brats75336013bra__ts
brava106414793bra_va_
bravers124715523bravers
braves115524083bra_ves
bravoes12418533bravoes
bravos114711393bra_vos
bravuras1343443bravuras
brawls115214333bra_wls
brawns115614083bra_wns
braws106425193bra__ws
braxies16711463braxies
brayers124511903brayers
brays106723113bra__ys
braza165214253bra_za_
brazens18418713brazens
brazers184513943brazers
brazes175522193bra_zes
brazils1867753brazils
breams104815043bream_s
brechams1745773brechams
bregma1134963bregma_
brims94721623br_im_s
bromal10313653br_omal
bromals1139743br_omals
bromes104719763br_omes
bromos104213313br_omos
brooms104915873broom_s
brumal1049503br_umal
brumes106417073br_umes
bushman1455693bushman
bushwas15105613bushwas
bwanas1157443bwa_nas
camas96333523_ca_mas
chacmas1638003chacmas
cramps125615563cra_mps
crams96229153cra_m_s
dharmas1356513dharmas
drachma1544303drachma_
drachmae1643933drachmae
drachmai1653243drachmai
drachms1534253drachm_s
drama85117423dra_ma_
drams86025833dra_m_s
drayman1335433drayman
fracas11311993fra_cas
frames115119863fra_mes
gamas85431363_ga_mas
gammas115714693_gammas
graham1237853grah_am
grama85620283gra_ma_
gramma11499803gramma_
grammar12406893grammar
grammars13345943grammars
grammes123611323grammes
grampas12399253grampas
gramps114114273gra_mps
grams85327313gra_m_s
grandmas1236923grandmas
grappas12357103grappas
hahas117118443_hah_as
halmas117017893_halmas
karmas123013733_karmas
lamas75532793_la_mas
llamas888973lla_mas
magmas115512503_magmas
mamas95930773_ma_mas
mammas94616403_mammas
miasmas1167743miasmas
plasmas113010753plasmas
praams10459643praam_s
prahus11458243prah_us
prajnas1635453prajnas
prams96125513pra_m_s
primas104418103pr_imas
ragas65326063_ra_gas
ragman94013713_ragman
raias54631123_ra_ias
raitas64417673_raitas
rajas127317723_ra_jas
ramal74622243_ra_mal
ramps96224633_ra_mps
rams65950773_ra_m_s
ramus76418283_ra_mus
raphias123511083_raphias
rayas85922053_ra_yas
rheas84816953_r_heas
shamas113717943sha_mas
shammas14358723shammas
sradhas1176153sradhas
taramas9612703taramas
tracheas13410273tracheas
trachomas16126413trachomas
tramps105114453tra_mps
trams75327673tra_m_s
trashman1345813trashman
trauma838803trauma_
ulamas8910453ula_mas
uraemias1046043uraemias
uranias72113813uranias

Search took 9 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271818.20316338.8
3Display Results1811810.0632873.0
 (SQL Overall)1786911818.67220605.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.