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

225 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
braggier1213645(None) 
baggier113611641b_aggier
bragger113810031bragg_er
craggier12116061craggier
draggier11135761draggier
bagger104619202b_agg_er
baggie102912192b_aggie_
baggies113814852b_aggies
boggier113711582b_oggier
bragged12449842bragg_ed
braggers12327902bragg_ers
braggiest13116782braggiest
bragging13359332bragging
brainier102510222brainier
brakier133812362bra_kier
brannier10218932brannier
brashier13389932brashier
brasier94516752bra_sier
brassier103310532brassier
brattier1047662brattier
brawlier13267042brawlier
brawnier13216722brawnier
brazier183911472bra_zier
buggier113611342b_uggier
dragger10309162dragg_er
dreggier1193552dreggier
druggier11134832druggier
faggier12309842_faggier
flaggier13105202flaggier
froggier1354642froggier
groggier1134342groggier
jaggier16339182_jaggier
naggier9309152_naggier
orangier947702orangier
quaggier1933852quaggier
raggies93214732_raggies
rangier83714352_rangier
saggier92912062_saggier
scraggier1344132scraggier
shaggier13116052shaggier
slaggier10126952slaggier
snaggier10136302snaggier
staggier10167512staggier
agger76420893__agg_er
aggie73415013__aggie_
aggies83515513__aggies
babier103515563b_a_bier
badger105415073b_adg_er
bagged114519903b_agg_ed
baggers113915693b_agg_ers
baggiest123011753b_aggiest
baggily1436043b_aggily
bagging123316983b_agging
bagpiper1542393b_agpiper
balkier134111983b_alkier
balmier113811513b_almier
banger94423633b_ang_er
bargainer1244563bargainer
barkier133814483b_arkier
barmier114313043b_armier
barnier93213673b_arnier
barrier94017733b_arrier
battier93515713b_attier
bawdier13378203b_awdier
beachier1538803beachier
beadier103513913bea_dier
beakier134012163bea_kier
beamier113411943bea_mier
bigger104315063b_igg_er
biggie103810933b_iggie_
biggies113813523b_iggies
bilgier10358533b_ilgier
blagging13319163blagging
blastier10249493blastier
blogger11448313blogg_er
boggler113910083b_oggler
brabbler11397373brabbler
bracer104620583bra__cer
braggart1245613braggart
braggest1296533braggest
braggy13337173bragg__y
braider105112993bra_ider
brailler1036883brailler
bramblier1543503bramblier
branchier1637133branchier
brander103915823bra_nder
brandied1259113brandied
brandies11714563brandies
branner94212373bra_nner
brasher124515233bra_sher
brasiers103710513bra_siers
brassie93411523brassie_
brassiere11365373brassiere
brassies103613533brassies
braver114719043bra__ver
brawer114216333bra__wer
brawler124310233bra_wler
brawlie12198153brawlie_
braxies16711463bra_xies
brayer115315313bra__yer
brazer174917533bra__zer
braziers19397193bra_ziers
breathier1435383breathier
breezier1934533breezier
brevier1237763br_evier
brickier16307163brickier
brier74527403br___ier
brigadier1343323brigadier
brighter1476663brighter
bringer104213353bring_er
brinier93613463br_inier
bronzier1935633bronzier
broodier1157433broodier
broomier1236873broomier
brownier13226913brownier
brushier13306973brushier
bugger104418723b_ugg_er
buggies114613813b_uggies
bulgier103911213b_ulgier
cagier93715933_ca_gier
cloggier1244253cloggier
crabbier14326803crabbier
craftier1376193craftier
cragged12479883cragg_ed
craggiest13116523craggiest
craggily1543703craggily
crampier14288903crampier
crankier14339163crankier
crappier14288133crappier
crawlier13216873crawlier
crazier183610743cra_zier
dagger95017293_dagg_er
doggier103810943_doggier
draffier1574323draffier
draftier1285263draftier
dragged11379553dragg_ed
draggers11357383dragg_ers
draggiest12126413draggiest
dragging12308103dragging
draggle1056103draggle_
draggled1254673draggled
draggles1145963draggles
dragster1034623dragster
drawlier12225253drawlier
druggie10134073druggie_
druggies11126223druggies
flagger12469343flagg_er
foggier12349913_foggier
fragged134010153fragg_ed
fragging14329423fragging
fringier1236543fringier
fuggier12348963_fuggier
gagger95016513_gagg_er
grabbier13316653grabbier
grainier9218893grainier
granger93514213grang_er
grapier103712603gra_pier
grassier9349283grassier
grazier173611133gra_zier
grungier1034983grungier
haggler12328933_haggler
jagger154016003_jagg_er
jaggies163311083_jaggies
jiggier16377823_jiggier
lagger85919833_lagg_er
leggier9368233_leggier
loggier93811143_loggier
mangier104114063_mangier
muggier11288943_muggier
nagger84016123_nagg_er
piggier113510003_piggier
progger11319373progg_er
puggier11309383_puggier
racier85120973_ra_cier
ragged94620263_ragg_ed
raggeder1143263_raggeder
raggedier1242523_raggedier
raggee84217603_ragg_ee
raggees93710913_raggees
ragging103516683_ragging
raggle83712883_raggle_
raggles93813283_raggles
rainier71614253_rainier
rallier73816273_rallier
rammier112811023_rammier
randier83618473_randier
ranger73925523_rang_er
rapier84019993_ra_pier
raspier93110633_raspier
rattier74015593_rattier
ridgier937883_ridgier
rigger85616713_rigg_er
rugger84414513_rugg_er
sagger84321073_sagg_er
sagier73717163_sa_gier
scragglier1442283scragglier
scroggier1343133scroggier
slangier9117933slangier
smoggier1243973smoggier
soggier93410883_soggier
spriggier1343843spriggier
stagger94212383stagg_er
staggie9138463staggie_
staggies101210323staggies
stagier83513443sta_gier
straggler11377273straggler
stragglier1243493stragglier
swagger12389333swagg_er
swaggie12135783swaggie_
swaggies13136693swaggies
tagger84017693_tagg_er
tangier83013903_tangier
trampier12318233trampier
trashier113210093trashier
trigger9329153trigg_er
twangier1254243twangier
twiggier1333073twiggier
vuggier12296813_vuggier
wagger113616013_wagg_er
wagglier1344323_wagglier
wiggier12418863_wiggier
wrangler1245473wrangler
wrathier1435903wrathier
wriggler13295263wriggler
wrigglier1462413wrigglier

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 Filter1786911461620.203880251.2
2DLD Change Limit1461622258.15617920.8
3Display Results2252250.1231829.3
 (SQL Overall)1786912258.48221067.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.