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

174 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
burettes104895(None) 
burette939851burette_
curettes1039311curettes
barbettes1348162barbettes
barrettes1149062barrettes
berettas1046732berettas
birettas1046512birettas
brunettes1144582brunettes
burets84321262bure_t_s
burkites1436672burkites
buttes84822562bu__ttes
curette939782curette_
curetted1137172curetted
cuvettes1335322cuvettes
fumettes1345772fumettes
lunettes836752lunettes
musettes1037432musettes
sureties8316582sureties
syrettes1136962syrettes
aigrettes1046393aigrettes
ambulettes1443083ambulettes
aretes64425353_are_tes
ariettes8411353ariettes
aureate72515283aureate_
aureoles838283aureoles
baguettes12115393baguettes
barbette1249113barbette_
bareges105212033bare_ges
barites94322333bar_ites
barquettes2174753barquettes
barrette1039783barrette_
barytes124611153bar_ytes
beetles9312083b_eetles
befretted1544373befretted
begetter11136313begetter
begetters12135043begetters
berates94126873ber_ates
bereaves1338273bereaves
berets85822523bere_t_s
beretta938463berett_a
berrettas1143853berrettas
besetter10137983besetter
besetters11136643besetters
bettas84913923b__ettas
betted94721163b__etted
better84723703b__etter
betters94422093b__etters
bimbettes1544153bimbettes
biremes1138773bire_mes
biretta947243birett_a
birrettas1143503birrettas
boletes9316063bole_tes
borates94823013bor_ates
boreases10310253boreases
bornites10310983bornites
bortzes1838223bor_tzes
brattles10199333b_rattles
breathes134212903b_reathes
breaths124411183b_reaths
bredes94818473b_re_des
brees75632553b_re__es
breezes18318693b_reezes
brents84717273b_rent_s
breves115516423b_re_ves
brevets12519393b_revets
brittles10178653b_rittles
britts84813443b_ritt_s
brunette1044723brunette_
brutes86118683b_r_utes
bugeyes1335513buge_yes
burbles114916803bur_bles
burbots1168673burbot_s
burdies104117563bur_dies
bureaus979293bure_aus
buret77444013bure_t__
burgages1236483burgages
burgees104915893bur_gees
burgesses1245513burgesses
burgles105615963bur_gles
buries84633273bur__ies
burkes124421313bur__kes
burkite1337003burkite_
burnets93813263burnet_s
burnies94017823bur_nies
burritos1044473burritos
bursate94111203bursate_
burses84425513bur__ses
bursitis1045033bursitis
bursted1039423bur_sted
burster9310293bur_ster
bursters1038983bursters
burstones1187153burstones
bursts85116243bur_st_s
burthen1236363bur_then
burthens1335383bur_thens
burtons9310853bur_tons
bustles93816323bu_stles
butenes9313033bute_nes
butes714535873bu___tes
butles84423913bu__tles
butte74924293bu__tte_
butted94722063bu__tted
butter84724233bu__tter
butters94521723bu__tters
butties93217953bu_tties
butts75824253bu__tt_s
casettes1039653casettes
corvettes1447433corvettes
courgettes1344123courgettes
creates95225203_creates
culottes1076293culottes
curates95323833cur_ates
curets84922343cure_t_s
curettages1342353curettages
curites93919863cur_ites
curvetted1543703curvetted
cuvette1235833cuvette_
dinettes9310193dinettes
duetted937023du_etted
duresses939173duresses
fouettes1137883fouettes
fretted113411853_fretted
fretter103412753_fretter
fretters113410303_fretters
fumette1245523fumette_
furcates1339883furcates
furmeties1446573furmeties
galettes93111153galettes
garottes978283garottes
gazettes18296863gazettes
genettes938303genettes
hurtles103913753hur_tles
laureates987683laureates
layettes1136263layettes
lunette737483lunette_
lurexes1436073lure_xes
mofettes1386083mofettes
murexes1636973mure_xes
muriates10312083muriates
musette938433musette_
navettes1136613navettes
octettes1045533octettes
palettes103112833palettes
parkettes15137593parkettes
pipettes1237563pipettes
pretties10615133_pretties
proettes10312763proettes
purees84721683pure__es
purities10316283purities
quartettes1943793quartettes
rentes65431193__rentes
reties65436193__reties
retted74826313__retted
rosettes8310343rosettes
rottes64524833__rottes
roulettes946523roulettes
soubrettes1243963soubrettes
strettas846423strettas
strette7310763strette_
strettos847113strettos
superettes1249743superettes
syrette1037183syrette_
tonettes839203tonettes
turgites937783turgites
turtles72914343tur_tles
ubieties1046913ubieties
umbrettes1344143umbrettes
urates65027763_ur_ates
ureases74416723_ureases
ureides8311103_ureides
ureter6313203_ure_ter
ureters7311823_ureters
vedettes1265943vedettes
videttes1266333videttes

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.436409841.7
2DLD Change Limit1461621747.07620656.0
3Display Results1741740.0632761.9
 (SQL Overall)1786911747.57523589.6
 
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.