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

326 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
brassies10361353(None) 
brasses93818351brass_es
brassie93411521brassie_
brassier103310531brassier
brassiest11369711brassiest
basses85428302b_ass_es
beasties102514652beasties
biasses94911652biass_es
blasties102113632blasties
bossies94116832b_ossies
braises93818872brais_es
brandies11714562brandies
brashes124518462bra_shes
brashier13389932brashier
brashiest14359862brashiest
brasier94516752bra_sier
brasiers103710512bra_siers
brasils9410972bra_sils
brassages1245262brassages
brassed103612372brass_ed
brasseries1246872brasseries
brassica1244872brassica
brassicas1344052brassicas
brassiere11365382brassiere
brassieres12274382brassieres
brassily1336622brassily
brassiness1235492brassiness
brassing112612302brassing
brassish1346432brassish
braxies16711462bra_xies
brisses94314312briss_es
dassies84418662_dassies
frasses104314512frass_es
glassies94012272glassies
grasses84117342grass_es
grassier9349282grassier
grassiest10309512grassiest
lassies74420102_lassies
prissies101712002prissies
prossies101515232prossies
rassles73513922_rassles
sassies74719262_sassies
tassies74918932_tassies
trasses74819322trass_es
wrasses103812592wrass_es
wrassles11376712wrassles
abrasives1444063abrasives
amasses93912853amass_es
argosies939523argosies
asses55629283__ass_es
assizes1638453__assizes
baases85218013b_aas_es
babies106123653b_a_bies
badasses1136173badass_es
baddies114017873b_addies
baffies153612943b_affies
bagasses1136313bagass_es
baggies113814853b_aggies
bailies94120203b_ailies
baldies105317703b_aldies
ballies93725743b_allies
bandies104124863b_andies
banshies131110663banshies
banties94324763b_anties
barbies114519593b_arbies
barflies1338303barflies
baronies10315023baronies
bases75644353b_a_s_es
bashes115631393b_a_shes
basics104915123b_a_sics
basifies13310493b_asifies
basils85717473b_a_sils
basins85722763b_a_sins
basis75429863b_a_si_s
basques18248673b_asques
basset85225383b_ass_et
bassets96414823b_assets
bassi77019323b_assi__
bassinet10312843b_assinet
bassinets1146323b_assinets
bassist9312743b_assist
bassists1037183b_assists
bassness1096743b_assness
bassos85313703b_ass_os
bastes85330383b_a_stes
bastiles10313353b_astiles
bawdies134613393b_awdies
bawties124214313b_awties
beanies93821093bea_nies
beastie92412433beastie_
beauties10229523beauties
bhisties1339003bhisties
bialies93618413bia_lies
biases84618433bia_s_es
biassed10418703biass_ed
biassing11307263biassing
biopsies1237403biopsies
blastie92411393blastie_
blastier10249493blastier
blastiest111710053blastiest
blesses93812393bless_es
blisses94911513bliss_es
bolshies1338693bolshies
bosses85925403b_oss_es
bossier93712423b_ossier
bossiest103112213b_ossiest
brabbles11349753brabbles
braces108427773bra__ces
braches144621223bra_ches
braes75735053bra___es
braggier12136453braggier
braggiest13116783braggiest
braids95015693bra__ids
brailles1039493brailles
brails84621293bra__ils
brainier102510233brainier
brainiest11209723brainiest
brains85125473bra__ins
braise84318753brais_e_
braised104014803brais_ed
braising113014563braising
braizes183112453bra_izes
brakes124923123bra__kes
brakier133812363bra_kier
brakiest143912243bra_kiest
brambles14308973brambles
branches153613803branches
brandied1259113brandied
brannier10218933brannier
branniest11199383branniest
brasher124515243bra_sher
brashest133511763bra_shest
brashness1436323brashness
brasil8713863bra_si_l
brasilins1146243brasilins
brass75428023bra_s__s
brassage1145283brassage
brassard1144683brassard
brassards1244063brassards
brassart1047503brassart
brassarts1143823brassarts
brasserie1145323brasserie_
brasswares1583733brasswares
brassy11509233brass__y
brattices1345553brattices
brattier1047663brattier
brattiest1148103brattiest
brattles10199333brattles
braunites1146723braunites
braveries1439103braveries
braves115524083bra__ves
bravoes12418533bra_voes
brawlie12198153brawlie_
brawlier13267043brawlier
brawliest14177193brawliest
brawnier13216723brawnier
brawniest14197103brawniest
brazes175522193bra__zes
brazier183911473bra_zier
braziers19397193bra_ziers
brazils1867753bra_zils
brewises1337213brewises
brewskies18132273brewskies
bries74942153br___ies
brinies93317923br_inies
brionies10310553brionies
brises84927613br_is_es
bristles101510433bristles
broadsides1443423broadsides
brollies1039533brollies
brookies1459143brookies
broses86524403br_os_es
brownies13189613brownies
browses124712693brows_es
bruises93212913bruis_es
brulyies1343423brulyies
brulzies1933983brulzies
brumbies1436533brumbies
brushes124014663br_ushes
brushier13306973brushier
brushiest14297543brushiest
bryonies1336843bryonies
bursaries1157643bursaries
busbies113011693b_usbies
busies85525263b__usies
busses85023383b_uss_es
bypasses1533833bypass_es
cassias93514343_cassias
cassines103116613_cassines
cassis84818853_cassi_s
cassises103811743_cassises
chasses124017503chass_es
chassis123910663chassi_s
cissies94116153_cissies
classes94717943class_es
classics12418873classics
classier10359083classier
classiest11309553classiest
classis93712723classi_s
crannies10313013crannies
crappies142911173crappies
crases85532313cra_s_es
crashes124618403cra_shes
crasis85020473cra_si_s
crasser94114343crass_er
crassest103411523crass_est
crassness1136213crassness
crazies183413853cra_zies
cresses94219813cress_es
crosses94220803cross_es
crossties1139023crossties
daisies84217093_daisies
dassie74615573_dassie_
dresses83716173dress_es
dressier956863dressier
dressiest1036823dressiest
dropsies1138703dropsies
droskies13186343droskies
drosses84513823dross_es
drossier956323drossier
drossiest1036523drossiest
easies64126633_ea_sies
embassies1344003embassies
erases64425403era_s_es
erasures837213erasures
eyasses10388023eyass_es
falsies103515013_falsies
flossies112810123flossies
fraises104215693frais_es
gasses75724783_gass_es
gassier83812573_gassier
gassiest93212523_gassiest
glasses84414273glass_es
glassie8329493glassie_
glassier9289083glassier
glassiest10279253glassiest
glassines10278043glassines
glossies93311253glossies
grannies9312613grannies
grassed93812793grass_ed
grassily1236433grassily
grassing103311973grassing
grassless1034303grassless
gravies11314093gra_vies
grosses84517683gross_es
gussies82813303_gussies
harasses11311033harass_es
hassles103411693_hassles
hissies103915823_hissies
hussies103213293_hussies
jassids1586143_jassids
kvasses14365503kvass_es
lasses64827593_lass_es
lassie64917743_lassie_
lassis65216703_lassi_s
lassoes74613853_lassoes
mashies12318253_mashies
masses85028713_mass_es
massier93615223_massier
massiest103314423_massiest
massifs1237743_massifs
missies93423983_missies
morasses1038903morass_es
nasties73520493_nasties
palsies94420273_palsies
pansies94521983_pansies
passes86030473_pass_es
passives13228823_passives
pasties94529813_pasties
patsies93919483_patsies
poussies1038113poussies
prairies10411453prairies
praises94121103prais_es
prases84429023pra_s_es
praxises1739063praxises
presses93523153press_es
prisses94816713priss_es
prissier10157873prissier
prissiest11178903prissiest
prosses94019513pross_es
prossie91812963prossie_
prosties101421193prosties
pussies93615693_pussies
quasses16209503quass_es
quassias1754933quassias
quassins1735793quassins
rabbies113416053_rabbies
rabies85226023_ra_bies
raggies93214733_raggies
raises64826543_rais_es
raisins72715343_raisins
rallies73823343_rallies
ramies84630463_ra_mies
randies84225663_randies
rases55447213_ra_s_es
rashes95330153_ra_shes
raspier93110643_raspier
raspiest10311283_raspiest
rassle63813203_rassle_
rassled83310453_rassled
rasures7312013_rasures
sasses64124393_sass_es
sassier73413233_sassier
sassiest83413623_sassiest
sissies73716603_sissies
strasses81311443strass_es
tansies74521243_tansies
tasses64826763_tass_es
tassie66017023_tassie_
trannies8415013trannies
transits8313503transits
trashes104119263tra_shes
trashier113210103trashier
trashiest123110643trashiest
tresses73719543tress_es
tressier847963tressier
tressiest937883tressiest
trusses73813643truss_es
trusties82712853trusties
urases63723563ura_s_es
wrasse9398773wrass_e_
wrassle10357173wrassle_
wrassled12325383wrassled
wrastles11328933wrastles
wussies103411083_wussies
zebrasses2043513zebrass_es

Search took 8 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 Filter1786911461620.406440125.6
2DLD Change Limit1461623266.89021213.6
3Display Results3263260.1262587.3
 (SQL Overall)1786913267.42224075.9
 
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.