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

265 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
brassier10331053(None) 
brashier13389931brashier
brasier94516751bra_sier
brassie93411521brassie_
brassiere11365381brassiere
brassies103613531brassies
grassier9349281grassier
blastier10249492blastier
bossier93712422b_ossier
braggier12136452braggier
brainier102510232brainier
brakier133812362bra_kier
brannier10218932brannier
brasher124515242bra_sher
brasiers103710512bra_siers
brassed103612372brass_ed
brasses93818352brass_es
brassica1244872brassica
brassieres12274382brassieres
brassiest11369712brassiest
brassily1336622brassily
brassing112612302brassing
brassish1346432brassish
brattier1047662brattier
brawlier13267042brawlier
brawnier13216722brawnier
brazier183911472bra_zier
brushier13306972brushier
classier10359082classier
crasser94114332crass_er
dressier956862dressier
drossier956312drossier
gassier83812572_gassier
glassier9289082glassier
massier93615222_massier
prissier10157872prissier
raspier93110642_raspier
sassier73413232_sassier
trashier113210102trashier
tressier847962tressier
amasser9418733amass_er
artsier768943ar_tsier
ashier94714833__ashier
babier103515573b_a_bier
baggier113611643b_aggier
balkier134111983b_alkier
ballsier1036523ballsier
balmier113811513b_almier
barkier133814483b_arkier
barmier114313043b_armier
barnier93213673b_arnier
barrier94017733b_arrier
baser74828923b_a_s_er
basher115123813b_a_sher
basifier1337313b_asifier
basses85428303b_ass_es
basset85225383b_ass_et
bassi77019323b_assi__
bassinet10312843b_assinet
bassist9312743b_assist
baster85333593b_a_ster
battier93515713b_attier
bawdier13378203b_awdier
beachier1538803beachier
beadier103513913bea_dier
beakier134012163bea_kier
beamier113411943bea_mier
beastie92412433beastie_
beasties102514653beasties
beastlier1144193beastlier
biassed10418703biass_ed
biasses94911653biass_es
biassing11307263biassing
bitsier9379073b_itsier
blaster94017303bla_ster
blastie92411393blastie_
blasties102113623blasties
blesser9329293bless_er
blousier1055663blousier
blowsier1335063blowsier
bluesier1034943bluesier
boaster94616433boa_ster
boskier13309173b_oskier
bossies94116833b_ossies
brabbler11397373brabbler
bracer104620583bra__cer
bragger113810043bra_gger
braider105112993bra_ider
brailler1036883brailler
braise84318753brais_e_
braised104014803brais_ed
braises93818873brais_es
braising113014563braising
bramblier1543503bramblier
branchier1637133branchier
brander103915823bra_nder
brandied1259113brandied
brandies11714563brandies
branner94212373bra_nner
brashes124518463bra_shes
brashiest14359853brashiest
brasil8713863bra_si_l
brasils9410973bra_sils
brass75428023brass___
brassage1145283brassage
brassages1245263brassages
brassard1144683brassard
brassart1047503brassart
brasserie1145323brass_erie
brasseries1246873brasseries
brassicas1344053brassicas
brassiness1235483brassiness
brassware1463813brassware
brassy11509233brass__y
braver114719043bra__ver
brawer114216333bra__wer
brawler124310233bra_wler
brawlie12198153brawlie_
braxies16711463bra_xies
brayer115315313bra__yer
brazer174917533bra__zer
braziers19397193bra_ziers
breathier1435383breathier
breezier1934533breezier
brevier1237763br_evier
brickier16307163brickier
brier74527403br___ier
brinier93613473br_inier
brisker134210293br_isker
brisses94314313briss_es
bristlier1144313bristlier
bronzier1935633bronzier
broodier1157433broodier
broomier1236873broomier
brownier13226913brownier
browser124911143brows_er
bruiser9349573bruis_er
brusher123813003br_usher
brusker13437853br_usker
brusquer1942643brusquer
bushier123712813b_ushier
busier85219723b__usier
bustier93916153b_ustier
cashier123713323_cashier
classer93614613class_er
crabbier14326803crabbier
craftier1376193craftier
craggier12116063craggier
crampier14288903crampier
crankier14339163crankier
crappier14288133crappier
crasher124616163cra_sher
crawlier13216873crawlier
crazier183610743cra_zier
creasier103210193creasier
crispier12297253crispier
crosier94116573cr_osier
crosser95015463cross_er
crustier10259533crustier
cuirassier1251263cuirassier
dashier114311183_dashier
dassie74615573_dassie_
dassies84418663_dassies
dossier83711693_dossier
draffier1574323draffier
draftier1285263draftier
draggier11135773draggier
dragster1034623dragster
drawlier12225253drawlier
dresser83611953dress_er
drowsier1284903drowsier
easier64218463_ea_sier
eraser64216333era_s_er
flashier1437103flashier
flossier11326973flossier
frasses104314513frass_es
friskier1535193friskier
frostier1148163frostier
frowsier1444893frowsier
fussier103610673_fussier
gasser75017773_gass_er
glassie8329493glassie_
glassies94012273glassies
glossier9358203glossier
grabbier13316653grabbier
grainier9218903grainier
grapier103712603gra_pier
grasper10389793gra_sper
grassed93812793grass_ed
grasses84117343grass_es
grassiest10309513grassiest
grassily1236433grassily
grassing103311973grassing
grazier173611133gra_zier
greasier9298083greasier
grislier935793grislier
grosser84313143gross_er
harasser1137033harass_er
hastier103916623_hastier
hissier103410503_hissier
lassie64917743_lassie_
lassies74420103_lassies
lassoer7379383_lassoer
marshier1337593marshier
measlier1036013measlier
messier93412923_messier
mossier94413813_mossier
mussier93314363_mussier
nastier74115293_nastier
orangier947713orangier
passer84721033_pass_er
pastier94320383_pastier
plashier1337613plashier
praiser93413943prais_er
presser93717623press_er
prissies101712003prissies
prosier93817483pr_osier
prossie91812953prossie_
prossies101515223prossies
pussier93711993_pussier
racier85120973_ra_cier
rainier71614263_rainier
raiser66620103_rais_er
rallier73816273_rallier
rammier112811023_rammier
randier83618473_randier
rangier83714353_rangier
rapier84019993_ra_pier
raser55633413_ra_s_er
rasher95024123_ra_sher
rasper83917333_ra_sper
rassle63813203_rassle_
rassled83310453_rassled
rassles73513923_rassles
raster64731443_ra_ster
rattier74015593_rattier
riskier1138423_riskier
rosier64221263_r_osier
rushier103411973_rushier
rustier74416363_rustier
sassies74719263_sassies
sissier73711363_sissier
tarsier74119253_tarsier
tassie66017023_tassie_
tassies74918933_tassies
tastier711817093_tastier
toastier846893toastier
trampier12318243trampier
transfer1138433transfer
trasher104416133tra_sher
trasses74819323trass_es
trusser74010263truss_er
trustier8268683trustier
vastier103613203_vastier
washier133611153_washier
waspier12259053_waspier
wrasse9398773wrass_e_
wrasses103812593wrass_es
wrassle10357173wrassle_
wrassled12325383wrassled
wrassles11376713wrassles
wrathier1435903wrathier
wristier1136863wristier
wussier10408083_wussier
yeastier1135393yeastier

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.1561145455.1
2DLD Change Limit1461622657.39019778.3
3Display Results2652650.1102409.1
 (SQL Overall)1786912657.65623340.0
 
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.