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

146 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
bourrees1012764(None) 
bourree91311341bourree_
bourtrees11154011bourtrees
bouchees15339532bouchees
bournes93615022bou_rnes
bourrides1244822bourrides
bourses94014302bou_rses
bourtree10135572bourtree_
burgees104915892b_urgees
burrers93814492b_urrers
bargees105415873b_argees
barrels94514363b_arrels
barrens94414323b_arrens
barres84427543b_arr_es
barrets94917103b_arrets
baubees11348713bau_bees
berries94423553b_erries
blurred10427803blurr_ed
blurrier1035163blurrier
blurriest1155153blurriest
blurters10348373blurters
boarders11408623boarders
bootees94114473bo_otees
boraces113716853bo_races
borages103917163bo_rages
boranes93720403bo_ranes
borates94823013bo_rates
boraxes163511633bo_raxes
bordels103911973bo_rdels
borders104317533bo_rders
boreas85421733bo__reas
boreen8314313bo__reen
boreens9310403bo_reens
borers85122683bo__rers
bores76448253bo__r_es
borides10515153bo_rides
borrows12349253bo_rrows
bortzes1838223bo_rtzes
bouchee143313543bouchee_
boucles113113003bou_cles
bouffes15388633bou_ffes
bougies103715183bou_gies
boulders113010033boulders
boules84925973bou__les
boulles93114123bou_lles
bouncers12309353bouncers
bounces113813683bou_nces
bounders114314113bounders
bounties10311403bounties
bouquets19244523bouquets
bourbons1245343bourbons
bourdons1136433bourdons
bourgeois1243743bourgeois
bourgeon1144683bourgeon
bourgeons1244393bourgeons
bourgs9459993bou_r_gs
bourne83714093bou_rne_
bourns84114063bou_r_ns
bourride1144403bourride
bourse84414333bou_rse_
boursins1037513boursins
bouses84931783bou__ses
bouviers1375003bouviers
boweries13312293boweries
brees75632553b___rees
bungees104513103b_ungees
burbles114916803b_urbles
burdens1039713b_urdens
burdies104117563b_urdies
burets84321263b_u_rets
burgee97120593b_urgee_
burgers103918573b_urgers
burgess10409343b_urgess
burgles105615963b_urgles
buriers94017193b_uriers
buries84633273b_u_ries
burkers133716623b_urkers
burkes124421313b_u_rkes
burlers94120273b_urlers
burleys12479673b_urleys
burners94115673b_urners
burnets93813263b_urnets
burnies94017823b_urnies
burred95820723b_urr_ed
burrer83718473b_urr_er
burrier93613553b_urrier
burriest102911213b_urriest
burros85114993b_urr_os
burrows12399093b_urrows
burrs74925653b_urr__s
burseed1049503b_urseed
burseeds1134783b_urseeds
burses84425513b_u_rses
burweed1347823b_urweed
burweeds1434103b_urweeds
corries94026793co_rries
corvees124613793co_rvees
coulees9315513cou_lees
courages11311393courages
couriers103213173couriers
coursers104412303coursers
courses94218893cou_rses
courters103015373courters
curries93723163_curries
dhurries1255583dhurries
dourines9311373dourines
dourness947683dourness
durries83817353_durries
flurries11188913flurries
fourteen1144503fourteen
fourteens1243343fourteens
gourdes9109383gou_rdes
gourmets1144153gourmets
gurries83515953_gurries
honorees1148773honorees
hourlies1138343hourlies
hurries103919653_hurries
journeys1843203journeys
koupreys1741733koupreys
lorries74518343lo_rries
louvres10356523louvr_es
mourners1036913mourners
murres85019043_murr_es
murreys12367323_murreys
murries94118673_murries
outsees72616433_outsees
pourers93513673pou_rers
pugrees10218523_pugrees
purees84721683_pu_rees
scurries102911483scurries
sirrees73410573_sirrees
slurries82710413slurries
soirees72411643so_irees
sorrels7310723so_rrels
sources9312173sou_rces
sourness839543sourness
spurrers10338463spurrers
spurreys13364603spurreys
spurries102311323spurries
surreys10489443_surreys
toupees938513tou_pees
tourers73512743tou_rers
tourneys1134013tourneys
turrets73010673_turrets
vouchees16337483vouchees
worries104117133wo_rries

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.420425454.8
2DLD Change Limit1461621466.67321903.5
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.15624970.8
 
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.